Referens övrigt

SELECT field1, field2,...,fieldn FROM table [WHERE ...] [ORDER BY ...]
SELECT * FROM table
SELECT AVG(field1) AS avgprice FROM table ...
SELECT SUM(field2) AS tot FROM table ...
SELECT MIN | MAX AS ...
SELECT COUNT(field1) ...
SELECT COUNT(*) ... (Även null värden räknas)
SELECT ALL | DISTINCT field1 ...
SELECT TOP n [PERCENT]
SELECT field1, field2 AS alias1, alias2

WHERE field = val | field > val | field >= val | field < val | field <= val | field <> val
WHERE field1 = val1 AND field2 = val2 | field1 = val1 OR field2 = val2
WHERE field LIKE 'a' | '*son' | 'a*' | [A-C*] | #1/1/1990# (* = %, ! = ^, ? = _ andra än MS)
WHERE field BETWEEN 1 AND 100
WHERE field IN ('val1', 'val2'...)
WHERE field ISNULL
WHERE NOT | NOT IN | NOT LIKE | NOT BETWEEN ...

ORDER BY fieldname2, fieldname1 DESC (ASC default)
ORDER BY 2,3
ORDER BY 2 DESC, 3

INSERT INTO table (field1, field2…) VALUES (val1, val2…)
REPLACE INTO table (field1, field2…) VALUES (val1, val2…) WHERE field1='…'
UPDATE table1 SET field1 = 'val1' field2 = 'val2'…. WHERE field2 = 'val2'
DELETE FROM table1 WHERE field1 = 'val1'

SELECT ... FROM ...
[WHERE ...]
[GROUP BY ...]
[HAVING ...]
[ORDER BY ...]
[LIMIT nRows] (LIMIT 5,3 ger rad 6 till 8)

SELECT ... FROM table1
[INNER] JOIN |
LEFT [OUTER] JOIN |
RIGHT [OUTER] JOIN |
CROSS JOIN
table2 ON table1.id = table2.id ...

CREATE VIEW name AS SELECT...;
DROP VIEW name

SELECT ... FROM ... WHERE ...
UNION [ALL]
SELECT ... FROM ... WHERE ...
UNION [ALL]
SELECT ... FROM ... WHERE ...
[ORDER BY ...]