Posts

Showing posts from February, 2020

Subqueries with Aggregate function

Subqueries with Aggregate function SELECT * FROM XXSD_EMP_TL EMPNO ENAME JOB MGR SAL COMM DEPTNO 7369 SMITH CLERK 7902 800 20 7499 ALLEN SALESMAN 7698 1600 300 30 7521 WARD SALESMAN 7698 1250 500 30 7566 JONES MANAGER 7839 2975 20 7654 MARTIN SALESMAN 7698 1250 1400 30 7698 BLAKE MANAGER 7839 2850 30 7782 CLARK MANAGER 7839 2450 10 7788 SCOTT ANALYST 7566 3000 20 7839 KING PRESIDENT 5000 10 ...