SQL Dialects Reference

Contents

 * 1) Introduction
 * 2) Data structure definition
 * 3) Data types
 * 4) Numeric types
 * 5) Character types
 * 6) Date and time types
 * 7) Binary types
 * 8) Large object types
 * 9) Misc types
 * 10) Delimited identifiers
 * 11) Auto-increment column
 * 12) Functions and expressions
 * 13) Math functions
 * 14) Trigonometric functions
 * 15) Numeric functions
 * 16) Aggregate functions
 * 17) Date and time functions
 * 18) String functions
 * 19) Misc expressions
 * 20) Select queries
 * 21) Subqueries
 * 22) Select without tables
 * 23) Limiting results of select query
 * 24) Hierarchical Queries
 * 25) Write queries
 * 26) Replace query
 * 27) Insert results from select query into existing table
 * 28) Save results from select query as new table
 * 29) Update returning
 * 30) /Transactions/
 * 31) Procedural language
 * 32) Stored procedures
 * 33) User-defined functions (UDFs)
 * 34) /SQL XML/
 * 35) /Administration/
 * 36) /References/