SELECT UPPER(ORIGINAL_FILE_NAME), ATTRIBUTE_CATEGORY, MAX(VERSION_NUMBER), COUNT(FILE_ID) FROM EDR_FILES_VL GROUP BY UPPER(ORIGINAL_FILE_NAME) ,ATTRIBUTE_CATEGORY
View Text - HTML Formatted
SELECT UPPER(ORIGINAL_FILE_NAME) , ATTRIBUTE_CATEGORY , MAX(VERSION_NUMBER) , COUNT(FILE_ID) FROM EDR_FILES_VL GROUP BY UPPER(ORIGINAL_FILE_NAME) , ATTRIBUTE_CATEGORY