Tag: databases
Questions Related to 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