Question 38: In SQL, how to select all the records from the table “Persons” where the value of column “FirstName” to be “Peter” and “LastName” to be “Jackson”? – LLODO

Question 38: In SQL, how to select all the records from the table “Persons” where the value of column “FirstName” to be “Peter” and “LastName” to be “Jackson”? A. SELECT * FROM Persons WHERE FirstName=”Peter” AND LastName=”Jackson” B. SELECT * FROM Persons WHERE FirstName‘Peter’ AND LastName‘Jackson’ C. SELECT FirstName=”Peter”, LastName=”Jackson” FROM Persons A is the […]

Question 12: In SQL, how to select all records from the Persons table with the value in the FirstName column sorted alphabetically between (and including) Hansen and Pettersen: – LLODO

Question 12: In SQL, how to select all records from the Persons table with the value in the FirstName column sorted alphabetically between (and including) Hansen and Pettersen: A. SELECT LastName>’Hansen’ AND LastName B. SELECT * FROM Persons WHERE LastName BETWEEN ‘Hansen’ AND ‘Pettersen’ C. SELECT * FROM Persons WHERE LastName>’Hansen’ AND LastName REMOVE is […]

Chuyển đến thanh công cụ