How can we display all the employees grouped together on the basis of deptno and sal in descending order?
SELECT ename, deptno, sal FROM emp GROUP BY deptno ORDER BY Sal DESC;