How can we display all the employees grouped together on the basis of deptno and sal in descending order?
1 Like
SELECT ename, deptno, sal FROM emp GROUP BY deptno ORDER BY Sal DESC;
Answered By
Select all records from emp table where deptno = 30 and sal > 1500.
Count number of managers (MGR column) and their salary in emp table.
What are single row and multiple row functions?
What is the significance of GROUP BY clause in an SQL query?