how to find max data in duplicate table values

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Mike01 SSChampion Points: 11395 More actions · Answer 1

select max(id) id , name, max(version) version

from versions

group by name

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

steveb. SSC-Forever Points: 46733 More actions · Answer 2

this query will work with the data supplied and also incases where the max version and max id are not on the same row

SELECT TableA.id, TableA.name, TableA.version from TableA

INNER JOIN (SELECT name, MAX(version ) AS version FROM TableA GROUP BY name) x

ON tableA.name = x.name and tableA.version = x.version