Multiple choice

Student Table:

|Student_ID|First_Name|Last_Name|Subject| |---|---|---|---| |101|Ajit|Sharma|Physics| |102|Ranjit|Singh|Maths| |103|Virat|Kohli|Sport| |104|Suresh|Saxena|Art| |105|Gagan|Chandra|Chemistry|

  1. SELECT student_id, first_name, last_name, subject FROM student WHERE subject != 'Chemistry'

  2. SELECT student_id, first_name, last_name, subject FROM student WHERE subject NOT IN ('Chemistry' )

  3. SELECT student_id, first_name, last_name, subject FROM student WHERE subject = 'Chemistry'

  4. Both (1) and (2)

  5. None of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Both will produce desired result.

Keep practicing — related questions