;WITH CTE AS ( SELECT [NO],[DATE],FLAG ,ROW_NUMBER() OVER(PARTITION BY [NO] ORDER BY [DATE] DESC) AS ROW_NUM FROM TABLE_NAME ) SELECT [NO],[DATE],FLAG FROM CTE WHERE ROW_NUM = 1;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)