When we write sentences, we always use a capital letter at the start and and a full stop, question mark or exclamation mark when we end a sentence. We also use capital letters for I and for proper ...
-- WHERE CLAUSE -- Display deptno, total sal and number of employees related to deptno 20 SELECT DEPTNO, SUM(SAL) AS TOTAL_SAL, COUNT(*) AS NO_OF_EMPLOYEES FROM EMP WHERE DEPTNO = 20 GROUP BY DEPTNO; ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback