Quick Reference Guide to SQL

At last! Here is a handy guide for anyone using a database management system that supports the industry-standard SQL. Included are concise descriptions and notes on the statements, major clauses, and subfunctions for the SQL's main components:

• Data Manipulation Language (DML)
• Data Control Language (DCL)
• Data Definition Language (DDL)

Entries are arranged alphabetically within each section to make information immediately accessible. And scores of great examples — for both interactive users and programmers — offer practical insights into common SQL usage. In addition, you'll find a convenient appendix that describes common data types, arithmetic operators, and reserved words used in SQL.

• Data Manipulation Language
• BEGIN DECLARE SECTION Statement
• CLOSE Statement
• DECLARE CURSOR Statement
• DECLARE CURSOR Statement (Dynamic SQL)
• DELETE Statement
• DELETE … WHERE CURRENT OF Statement
• DESCRIBE Statement (Dynamic SQL)
• END DECLARE SECTION Statement
• END-EXEC Statement terminator
• EXEC-SQL Statement Prefix
• EXECUTE Statement (Dynamic SQL)
• Expressions
• FETCH Statement
• FETCH Statement (Dynamic SQL)
• Function: AVG
• Function: COUNT
• Function: MAX
• Function: MIN
• Function: SUM
• FROM Clause
• GROUP BY Clause
• HAVING Clause
• INCLUDE Directive
• INSERT Statement
• INTERSECT Query Operator
• Joins
• MINUS Query Operator
• OPEN Statement
• OPEN Statement (Dynamic SQL)
• ORDER BY Clause
• Predicate: BETWEEN
• Predicate: Comparison
• Predicate: EXISTS
• Predicate: IN
• Predicate: LIKE
• Predicate: NULL
• Predicate: Quantified (SOME, ANY, ALL)
• PREPARE Statement (Dynamic SQL)
• Search-condition
• SELECT Statement
• SELECT … INTO Statement
• subSELECT Clause
• UNION Query Operator
• UPDATE Statement
• UPDATE … WHERE CURRENT OF Statement
• WHENEVER Directive
• WHERE Clause
• Data Definition Language
• ALTER TABLE Statement
• COMMENT ON Statement
• CREATE INDEX Statement
• CREATE SYNONYM Statement
• CREATE TABLE Statement
• CREATE VIEW Statement
• DROP INDEX Statement
• DROP SYNONYM Statement
• DROP TABLE Statement
• DROP VIEW Statement
• UPDATE STATISTICS Statement
• Data Control Language
• COMMIT Statement
• GRANT Statement
• LOCK TABLE Statement
• REVOKE Statement
• ROLLBACK Statement
• Appendixes
• Common Data types
• Arithmetic Operators
• Reserved Words

This one wasn't complete even in 1989, when it was written.