SID ID Name version 1 1 A 1.0 2 1 B 1.1 3 1 C 1.2 4 2 D 1.0
SID ID Name version 3 1 C 1.2 4 2 D 1.0
with cte(ID,version) as ( select distinct ID,max(version) from Table_Name group by ID ) select SID,t.ID,Name,t.version from Table_Name t join cte c on t.version = c.version and t.ID = c.ID
SELECT t1.* FROM (SELECT * FROM YourTable) AS t1 RIGHT JOIN (SELECT [ID], MAX([Version]) AS [Version] FROM YourTable GROUP BY [ID]) AS t2 ON t1.[ID] = t2.[ID] AND t1.[Version] = t2.[Version]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)