SELECT DEPTNO,COUNT(EMPNO) FROM EMP GROUP BY DEPTNO HAVING COUNT(*) >= 3
Objective : Having clause
|
| The main purpose of GROUP BY us to perform aggregation operations, like SUM, AVG, MIN , MAX AND COUNT. The aggregations are done after forming the groups. |
| Dept Table
|
| oRACLE |
| PostgreSQL
|
| MySQL
|