Informatics Practices

Count number of managers (MGR column) and their salary in emp table.

SQL Queries

2 Likes

Answer

SELECT COUNT(MGR), COUNT(Sal) 
FROM emp;

Answered By

2 Likes

Related Questions

Select all records from emp table where deptno = 10 or 40.
View Answer

Select all records from emp table where deptno = 30 and sal > 1500.
View Answer
How can we display all the employees grouped together on the basis of deptno and sal in descending order?
View Answer
What are single row and multiple row functions?
View Answer