Q:

How to select all data from student table starting the name from letter \'r\'?

mhmadesk

Save to bookmark

|

2022-07-08

|

524

Medium

0

How to select all data from student table starting the name from letter 'r'?

SELECT * FROM student WHERE name LIKE \'r%\';
SELECT * FROM student WHERE name LIKE \'%r%\';
SELECT * FROM student WHERE name LIKE \'%r\';
SELECT * FROM student WHERE name LIKE \'_r%\';

Database, MCQ Questions, Database MCQ-questions,

login and add your own answer to this question

All Answers

mhmadesk

2022-07-08

need an explanation for this answer? contact us directly to get an explanation for this answer

(a).SELECT * FROM student WHERE name LIKE 'r%';

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)