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

Question

Answer

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

Answer

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

Answer

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

Answer

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

Crowdly