בחר את הגירסה האחרונה בלבד:

SELECT T1.* FROM dbo.sysdtspackages AS T1 INNER JOIN ( SELECT [name], [id], MAX([createdate]) AS [createdate] FROM dbo.sysdtspackages GROUP BY [name], [id]) AS T2 ON T1.[id] = T 2.[id] AND T1.[createdate] = T2.[createdate]

בחר את X הגירסאות האחרונות כאשר X הוא מספר הגירסאות להעברה:

	SELECT T1.* FROM dbo.sysdtspackages AS T1 INNER JOIN ( SELECT T2.[name] , T2.[id], T2.[createdate] FROM dbo.sysdtspackages T2 GROUP BY T2.[name], T2.[id], T2.[createdate] HAVING T2.[createdate] IN (SELECT TOP X T3.[createdate] FROM dbo.sysdtspackages T3 WHERE T2.[id] = T3.[id] ORDER BY T3.[createdate] DESC) ) AS T2 ON T1.[id] = T2.[id] AND T1.[createdate] = T2.[createdate]