Матеріали курсу Check your knowledge: DevOps Tests та відповіді на тести | softserve.academy

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’?

SELECT first_name FROM STUDENTS WHERE first_name LIKE 'A'

SELECT first_name FROM STUDENTS WHERE first_name

LIKE 'A%';

100%

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

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

Переглянути це питання

Crowdly