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 first_name LIKE ‘S%’

  2. SELECT * FROM student WHERE name LIKE ‘S%’

  3. SELECT * first_name FROM student WHERE first_name LIKE ‘S%’

  4. SELECT * FROM student WHERE first_name LIKE ‘S’

  5. None of the above

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

This is correct SQL query to get specified records.