Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 60 of 78

Simple Queries in SQL — Question 14

Back to all questions
14
Question

Question 14

Consider the following table namely Employee :

Employee_idNameSalary
1001Misha6000
1009Khushi4500
1018Japneet7000

Which of the names will not be displayed by the below given query ?

SELECT name FROM employee WHERE employee_id > 1009 ;
  1. Misha, Khushi
  2. Khushi, Japneet
  3. Japneet
  4. Misha, Japneet
Answer

Misha, Khushi

Reason — The query SELECT name FROM employee WHERE employee_id > 1009; retrieves the names of employees whose employee_id is greater than 1009. Japneet has an employee_id of 1018, which is greater than 1009, so Japneet will be displayed. But the question asks for the names which will not be displayed by the query. Hence, the correct answer will be Misha, Khushi, as they have employee_id ≤ 1009.