How to find MAX() from COUNT()?

Question

SQL

SELECT COUNT(bjishk_masnagitutyun.masnagitutyun_id),masnagitutyun_id
FROM bjishk_masnagitutyun
GROUP BY masnagitutyun_id
ORDER BY masnagitutyun_id DESC LIMIT

Answer 1

Depending on the database can be done via HAVING

Answer 2

ORDER BY COUNT(masnagitutyun_id) DESC LIMIT 1
if there is an index on masnagitutyun_id, it will work quickly in almost all subds