Tag: databases

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

SELECT * FROM Persons WHERE FirstName<>'Peter'

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

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

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

True

False

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons ORDER FirstName DESC

OPEN

EXTRACT

SELECT

GET

UPDATE

MODIFY

SAVE

SAVE AS

ADD NEW

INSERT INTO

ADD RECORD

INSERT NEW

Strong Question Language

Structured Query Language

Structured Question Language

Strong Query Language

SELECT * FROM Persons

SELECT [all] FROM Persons

SELECT Persons

SELECT FROM Persons

SELECT DIFFERENT

SELECT UNIQUE

SELECT DISTINCT

SELECT EXACT