SELECT emp_jobcode ,  count(*) FROM employee GROUP BY emp_jobcode ORDER BY count(*) DESC LIMIT 1
What is the count and code of the job with the most employee?
SELECT emp_jobcode , count ( * ) FROM employee GROUP BY emp_jobcode ORDER BY count ( * ) DESC LIMIT 1
select emp_jobcode , count ( * ) from employee group by emp_jobcode order by count ( * ) desc limit value
What is the count and code of the job with the most employee ?