;WITH cte AS ( SELECT id, address1, [date], ROW_NUMBER() OVER (PARTITION BY id ORDER BY [date] DESC) AS RN FROM YourTable ) SELECT id, address1, [date] FROM cte WHERE RN = 1;
No comments:
Post a Comment