Consider the following
table

STUDENTS(student_code, first_name, last_name,
email,

phone_no, date_of_birth, honours_subject, percentage_of_marks).

Which of the following
query will display all the students whose first name starts
with the character ‘A’?

Question

Consider the following
table

STUDENTS(student_code, first_name, last_name,
email,

phone_no, date_of_birth, honours_subject, percentage_of_marks).

Which of the following
query  will  display all the students whose first name starts
with the character ‘A’?

Answer

SELECT first_name FROM STUDENTS WHERE first_name
LIKE 'A%';

Answer

SELECT  first_name FROM STUDENTS WHERE first_name LIKE '%A';

Answer

SELECT  first_name FROM STUDENTS WHERE first_name LIKE 'A'

Answer

SELECT  first_name FROM STUDENTS WHERE first_name LIKE '%A%';

Crowdly