Informatics Practices
How can we display all the employees grouped together on the basis of deptno and sal in descending order?
SQL Queries
1 Like
Answer
SELECT ename, deptno, sal
FROM emp
GROUP BY deptno
ORDER BY Sal DESC;
Answered By
1 Like
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
1 Like