Expand|Select|Wrap|Line Numbers
- SELECT MimeType,
- SUM(DataSize)/1024 as Total_Size_MB,count(DocID) as Total_No_Doc FROM DVersData group by MimeType
Expand|Select|Wrap|Line Numbers
- SELECT DocID
- , MAX([Version]) AS [MaxVersion]
- FROM dversdata (nolock)
- GROUP BY DocID
how to modify the first query to include only the latest version SUM(DataSize) And count(DocID) ?