Course 2277 Course Materials & Test Answers | virt.lac.lviv.ua

Як вибрати всі рядки з таблиці Persons, для яких значення поля FirstName є "John" і LastName – "Smith"?

a. SELECT FirstName = ‘John’, LastName = ‘Smith’ FROM Persons;

c. SELECT * FROM Persons WHERE FirstName <> ‘John’ AND LastName <> ‘Smith’;

b. SELECT * FROM Persons WHERE FirstName is ‘John’ AND LastName is ‘Smith’;

d. SELECT * FROM Persons WHERE FirstName = ‘John’ AND LastName = ‘Smith’.

100%

View this question

Crowdly