Tag: databases

INSERT NEW

ADD NEW

ADD RECORD

INSERT INTO

SELECT FirstName FROM Persons

EXTRACT FirstName FROM Persons

SELECT Persons.FirstName

SELECT * FROM Persons

COLLAPSE

REMOVE

DELETE

TRUNCATE

SELECT [all] FROM Persons

SELECT * FROM Persons

SELECT *.Persons

SELECT Persons

SELECT * FROM Persons WHERE FirstName <> 'Peter'

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

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

SELECT * FROM Persons WHERE FirstName='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 FirstName='%a%'

SELECT DISTINCT

SELECT DIFFERENT

SELECT UNIQUE

SELECT ALL

ORDER

ORDER BY

SORT BY

SORT

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons SORT 'FirstName' DESC

123

12

123456

456