Slq Quiz

Strong Question Language Structured Query Language Structured Question Language

GET OPEN SELECT

MODIFY SAVE UPDATE

ADD RECORD INSERT INTO INSERT NEW

EXTRACT FirstName FROM Persons SELECT FirstName FROM Persons SELECT Persons.FirstName

SELECT * FROM Persons WHERE FirstName<>'Peter' SELECT * FROM Persons WHERE FirstName='Peter' SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

SELECT * FROM Persons WHERE FirstName LIKE '%a' SELECT * FROM Persons WHERE FirstName LIKE 'a%' SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen' SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen' SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons