Select * from table where

A. SELECT * FROM student WHERE name LIKE ‘r%’;

B. SELECT * FROM student WHERE name LIKE ‘%r%’;

C. SELECT * FROM student WHERE name LIKE ‘%r’;

D. SELECT * FROM student WHERE name LIKE ‘_r%’;

Answer: Option A