SQL · Question 2 · Easy

SQL question 2

Table Employee:
id | name | dept | salary
1 | Asha | HR | 30000
2 | Ravi | IT | 50000
3 | Neha | IT | 60000
4 | Karan | Sales | NULL
5 | Priya | HR | 45000
6 | Vikram | IT | 50000

What does the following query return?

SELECT COUNT(*), COUNT(salary) FROM Employee;
  1. 6 and 5
  2. 6 and 6
  3. 5 and 5
  4. 5 and 6
Answer and explanation

Answer: A. 6 and 5

Explanation: COUNT(*) counts all 6 rows. COUNT(salary) skips NULLs, so Karan's row is not counted and the result is 5.

Previous: Which SQL clause is used to filter groups formed by GROUP BY, for example to… · Next: Which SQL command removes all rows from a table but keeps the table structure…

Practise sql

Try a fresh set of sql questions with an explanation after every answer, free and without signing up: SQL practice. Or sit a full placement mock test.

More sql questions

More technical & programming practice

Operating Systems · Computer Networks · Software Engineering · Cloud & DevOps · GenAI Basics · Pseudo-code · C Programming · Java

LogicWiz Exams home · All practice topics · Placement mock tests · Daily 10 challenge