🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: Filtering and Sorting: all 10 questions

Quiz: Filtering and Sorting · Question 7 of 10

How many rows does SELECT name FROM employees WHERE deptid < 10 return for the company table?

How many rows does SELECT name FROM employees WHERE dept_id <> 10 return for the company table?

  1. A.4
  2. B.7
  3. C.3
  4. D.0
Answer & explanation

Correct answer: 3

Neha, Kabir and Om match. Arjun's dept_id is NULL, and NULL <> 10 is unknown, so his row is not returned.

Can you get the rest right without peeking?

Take the timed Quiz: Filtering and Sorting quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →