Tag: databases

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy', 'Jackson')

INSERT INTO Persons (LastName) VALUES ('Olsen')

INSERT ('Olsen') INTO Persons (LastName)

INSERT INTO Persons ('Olsen') INTO LastName

INSERT INTO Persons ('Olsen')

DELETE ROW FirstName='Peter' FROM Persons

DELETE FROM Persons WHERE FirstName = 'Peter'

DELETE FirstName='Peter' FROM Persons

REMOVE FROM Persons WHERE FirstName = 'Peter'

DELETE

COLLAPSE

REMOVE

ERASE

EXTRACT FirstName FROM Persons

SELECT FirstName FROM Persons

SELECT Persons.FirstName

SELECT * FROM Persons

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

SELECT * FROM Persons WHERE FirstName='Jackson' AND LastName='Peter'

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

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

SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

SELECT LastName<>'Hansen' AND LastName<>'Pettersen' FROM Persons

SORT BY

SORT

ORDER

ORDER BY

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

SELECT COUNT(*) FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COLUMNS() FROM Persons

SELECT COUNT() FROM Persons