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