Informatics Practices

Count the total salary deptno wise where more than 2 employees exist.

SQL Queries

3 Likes

Answer

SELECT deptno, SUM(sal) AS TOTALSAL
FROM emp
GROUP BY deptno
HAVING COUNT(empno) > 2; 

Answered By

2 Likes


Related Questions