How To Get The Max Count When Group By Some Other Field

1.	How To Get The Max Count When Group By Some Other Field
Answer» ANSWER : SELECT USER_UPDATED, COUNT (USER_UPDATED) AS COUNT1 FROM CGDEV4.TWC39 GROUP BY USER_UPDATED HAVING COUNT (USER_UPDATED) &GT;= ALL (SELECT COUNT (USER_UPDATED) FROM CGDEV4.TWC39 GROUP BY USER_UPDATED);

Discussion