Subqueries with Group by and Having Clause
Subqueries with Group by and Having Clause select * from XX_EMP_TL EMPNO ENAME JOB SAL DEPTNO LOCID 7369 SMITH CLERK 800 20 100 7499 ALLEN SALESMAN 1600 30 101 7521 WARD SALESMAN 1250 30 100 7566 JONES MANAGER 2975 20 101 7654 MARTIN SALESMAN 12000 30 100 7698 BLAKE MANAGER 10000 30 101 7782 CLARK MANAGER 2450 10 100 7788 SCOTT ANALYST 3000 20 102 7839 KING PRESIDENT 5000 10 100 7844 TURNER SALESMAN 1500 30 102 78...