sql query latest version of document

[lsauravbi]

I have this first query which gives the mimetype and sum of their total datasize and count of number of document

SELECT MimeType,
SUM(DataSize)/1024 as Total_Size_MB,count(DocID) as Total_No_Doc FROM DVersData group by MimeType

This second query gives the latest version of every document type

SELECT  DocID
           , MAX([Version]) AS [MaxVersion]
    FROM    dversdata (nolock)
    GROUP BY DocID

There is requirement that the result should have the latest version sum And count included in the result where as first query include all the sum of all versions of document and count.
how to modify the first query to include only the latest version SUM(DataSize) And count(DocID) ?

[Rabbit]

Please use code tags when posting code or formatted data.

Join the latest version query to the original table to filter for only the most recent.

[ck9663]

If you need just the last version, would it be just a single record and there's no need to sum anything?


~~~ CK

[lsauravbi]

I need the sum of all document of particular MIME type..but its should include only the latest version of document

[Rabbit]

I understand that, did you try what I suggested in post #2?