← 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?
- A.4
- B.7
- C.3
- 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 →