sql query to find latest version of stored document

[lsauravbi]

I have table having column which stores documentid and another column storing the version of document.I want query to find out the only the latest version of document?
can any one help

[NeoPa]

Something like this should do you :

SELECT   [DocumentID]
       , MAX([Version]) AS [MaxVersion]
FROM     [TableName]
GROUP BY [DocumentID]