Count of Collected Files

This will give you a count of collected files.

SELECT vCollectedFile.FileName, Count(vCollectedFile.FileName) AS ‘Count’
FROM vCollectedFile vCollectedFile
GROUP BY vCollectedFile.FileName
ORDER BY vCollectedFile.FileName

Leave a Reply

Your email address will not be published. Required fields are marked *