Jump to content

SQL Dialects Reference

Edit links
75% developed
From Wikibooks, open books for an open world
 A Wikibookian suggests that Converting MySQL to PostgreSQL be merged into this book because:
Huge redundant parts

Discuss whether or not this merger should happen on the discussion page.
A Wikibookian suggests that Oracle and DB2, Comparison and Compatibility be merged into this book because:
Huge redundant parts

Discuss whether or not this merger should happen on the discussion page.

This book requires that you first read Structured Query Language.

A printable version of SQL Dialects Reference is available. (edit it)

A PDF version is available. (info)


Contents

  1. Introduction
  2. Data structure definition
    1. Data types
      1. Numeric types
      2. Character types
      3. Date and time types
      4. Binary types
      5. Large object types
      6. Misc types
    2. Delimited identifiers
    3. Auto-increment column
  3. Functions and expressions
    1. Math functions
      1. Trigonometric functions
      2. Numeric functions
      3. Aggregate functions
    2. Date and time functions
    3. String functions
    4. Misc expressions
  4. Select queries
    1. Subqueries
    2. Select without tables
    3. Limiting results of select query
    4. Hierarchical Queries
  5. Write queries
    1. Replace query
    2. Insert results from select query into existing table
    3. Save results from select query as new table
    4. Update returning
  6. Transactions
  7. Procedural language
    1. Stored procedures
    2. User-defined functions (UDFs)
  8. SQL XML
  9. Administration
  10. References

See also

Retrieved from "https://en.wikibooks.org/w/index.php?title=SQL_Dialects_Reference&oldid=3468705"