Introduction to SQL
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%';

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

all records with even partial criteria met are to be returned.
all columns of the table are to be returned.
all records meeting the full criteria are to be returned.
None of these

ANSWER DOWNLOAD EXAMIANS APP