Count number of managers (MGR column) and their salary in emp table.
1 Like
SELECT COUNT(MGR), COUNT(Sal) FROM emp;
Answered By
2 Likes
Select all records from emp table where deptno = 10 or 40.
Select all records from emp table where deptno = 30 and sal > 1500.
How can we display all the employees grouped together on the basis of deptno and sal in descending order?
What are single row and multiple row functions?