SELECT SUM(SAL) FROM EMP WHERE DEPTNO=20 AND JOB='ANALYST'; SELECT DEPTNO,COUNT(*) FROM EMP GROUP BY DEPTNO; SELECT JOB,COUNT(*) FROM EMP GROUP BY JOB; SELECT JOB,MIN(SAL), FROM EMP GROUP BY JOB; ...
16. a) Write a PL/SQL code for creation of procedure to view some specified columns from a table. Write a PL/SQL code for creation of procedure to view some specified columns from a ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results