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 FROM student Where first_name IN ('Virat', 'Suresh')

  2. SELECT student_id, first_name, last_name FROM student Where first_name Like ('Virat', 'Suresh')

  3. SELECT student_id, first_name, last_name FROM student Where first_name IN ('Virat' and 'Suresh')

  4. SELECT student_id, first_name, last_name FROM student Where first_name EXISTS ('Virat', 'Suresh')

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

This is a correct query for the specified result.

Keep practicing — related questions