General Questions on Structured Query Language (SQL) related Questions and Answers

Question :   How to select all data from student table starting the name from letter 'r'? 1. SELECT * FROM student WHERE name LIKE 'r%'; 2. SELECT * FROM student WHERE name LIKE '%r%'; 3. SELECT * FROM student WHERE name LIKE '%r'; 4. SELECT * FROM student WHERE name LIKE '_r%'; Answer :   1 - SELECT * FROM student WHERE name LIKE 'r%';