sql_having_orderby1

Objective: having count order by

SELECT JOB,DEPTNO,COUNT(EMPNO) FROM EMP GROUP BY JOB, DEPTNO HAVING COUNT(*) >= 1 order by 3,2

Oracle

PostgreSQL

MySQL