clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591614 fiddles created (45702 in the last week).

WITH yourTable AS ( SELECT '2019-03-20' AS REPORT_DATE, 'GRS333' AS ID_NUMBER UNION ALL SELECT '2019-03-20', 'GRS386' UNION ALL SELECT '2019-03-20', 'GRS367' UNION ALL SELECT '2019-03-20', 'GRS311' UNION ALL SELECT '2019-03-18', 'GRS313' UNION ALL SELECT '2019-03-18', 'GRS313' UNION ALL SELECT '2019-03-18', 'GRS313' UNION ALL SELECT '2019-01-11', 'GRS367' ) SELECT REPORT_DATE, COUNT(*) AS cnt FROM yourTable GROUP BY REPORT_DATE ORDER BY COUNT(*) DESC LIMIT 2;
REPORT_DATE cnt
2019-03-20 4
2019-03-18 3
 hidden batch(es)