CROSS APPLY to get TOP 1 of each Group

Transact-SQL
2

Hi

this is my solution

I am not expert

SQL 
SELECT * FROM (SELECT 1 as abc) D 
CROSS APPLY 
   ( 
   select * 
   from ( SELECT *, ROW_NUMBER() OVER (PARTITION BY fGroup_ID ORDER BY fDate_Created) AS My_Row_ID from #tempTable) E
   WHERE E.My_Row_ID = D.abc
   ) A 
GO
1 Like