Home »
MCQs »
MySQL MCQs
What will the following statement return? Where student_details is the table name and student_name is the column name?
29. What will the following statement return?
SELECT * FROM student_details WHERE Student_name LIKE 'S%';
Where student_details is the table name and student_name is the column name?
- It will return the name starting with s
- It will return the name ending with s
- It will return the name who has s in between
Answer: A) It will return the name starting with s
Explanation:
The statement will return the name starting with s