Forum Discussion
ROW_NUMBER Without ORDER BY
HELLO,
I went to get only the first row from each group by [REF]
1 Reply
The easiest way is to use a CTE = Common Table Expression, like
;WITH cte AS (SELECT ROW_NUMBER() OVER (...) AS row, Col1, ... FROM yourTable) SELECT * FROM cte WHERE cte.row = 1
