Does anyone know if this query can be used in in a LOAD statement? I'm trying to JOIN to tables and need to only pull the top record so there are no duplicates.
SELECT *
FROM your_table
INNER
JOIN (
SELECT your
, fields
, Row_Number() OVER (PARTITION BY SessionStartTime ORDER BY ChTimestamp ASC) As row_num
