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 * FROM student WHERE subject != ’physics’ and subject != ’maths’

  2. SELECT * FROM student WHERE subject != ’physics’, subject != ’maths’

  3. SELECT * FROM student WHERE subject NOT IN (’physics’, ’maths’)

  4. Both (1) and (3)

  5. None of the above

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Both are the correct queries.