> select salary, count(*) occurs from payroll > group by salary having occurs = > (select count(*) c from payroll group by salary > order by c desc limit)
OR
select salary, count(*) from payroll group by salary
having count(*) = (select max(cnt) from
(select count(*) cnt from payroll group by salary))
Regards
