[MSSQL] 找出每個GROUP的第一筆

SELECT *
FROM (
 SELECT ROW_NUMBER() OVER(PARTITION BY [column2],[column3] ORDER BY [column1]) as rown,
 *
 FROM [TABLE1] ) AS T1
WHERE rown = 1