Student Table:|Student_ID|First_Name|Last_Name|Subject| |... | Questions and Answers on competitive exams like GATE exam, entrance tests, fun games, and much more

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|

SELECT * FROM student WHERE subject=’Maths’ OR subject='Physics’ OR subject=’sport’
SELECT * FROM student WHERE subject IN (’Maths’, ’Physics’, ’sport’)
SELECT * FROM student WHERE subject=’Maths’, subject='Physics’, subject=’sport’
Both (1) and (2)
Both (2) and (3)

Reveal answer Fill a bubble to check yourself

Student Table:

Keep practicing — related questions