Duplicate Records using JOIN

[Anonymous]

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

  FROM your_table

  ) As x

WHERE x.row_num = 1