Getting max record from counts

SELECT CASEID
, SOURCEUSERID, count(*)
, ROW_NUMBER() OVER (PARTITION BY CASEID ORDER BY COUNT(*) DESC) AS RN
FROM LGNCC_CLOSEDCASEEVENTS WHERE caseid = 1086297
GROUP BY CASEID, SOURCEUSERID

Advertisement