SQL Quick Reference Guide
Statements
SELECT [ DISTINCT ] * | LIST OF COLUMNS, FUNCTIONS, CONSTANTS
FROM LIST OF TABLES OR VIEWS
[ WHERE CONDITION(S) ]
[ ORDER BY ORDERING COLUMN(S) [ ASC | DESC ] ]
[ GROUP BY GROUPING COLUMN(S) ]
[ HAVING CONDITION(S) ]
DELETE FROM TABLE NAME
[ WHERE CONDITION(S) ]
INSERT INTO TABLE NAME
[ (COLUMN LIST) ]
VALUES (VALUE LIST)
UPDATE TABLE NAME
SET COLUMN NAME = VALUE
[ WHERE CONDITION ]
Functions
Function Purpose
SUM Total of the values in a field.
AVG Average of the values in a field.
MIN Lowest value in a field.
MAX Highest value in a field.
COUNT Number of values in a field, not counting Null (blank) values.
Predicates
Predicate Description
BETWEEN ... AND Compares a value to a range formed by two values.
IN Determines whether a value exists in a list of values or a table.
LIKE Compares, in part or in whole, one value with another.
JOIN Joins two tables.
Data Definition
CREATE TABLE TABLE_NAME
( COLUMN_NAME DATA_TYPE [(SIZE)] COLUMN_CONSTRAINT,
[, other column definitions,...]
[, primary key constraint]
)
ALTER TABLE TABLE_NAME ADD | DROP | MODIFY
( COLUMN_NAME DATA_TYPE [(SIZE)] COLUMN_CONSTRAINT,
[, other column definitions,...]
)
DROP TABLE TABLE_NAME
CREATE [UNIQUE] [ASC | DESC] INDEX INDEX_NAME
ON TABLE_NAME ( COLUMN_LIST )
DROP INDEX INDEX_NAME ON TABLE_NAME
CREATE VIEW VIEW_NAME AS QUERY_NAME
CONSTRAINT CONSTRAINT_NAME
{PRIMARY KEY | UNIQUE | NOT NULL |
REFERENCES FOREIGN_TABLE [(FIELD_LIST)]}