411 REFERENCE · Wikibooks
SQL Dialects Reference
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
Converting MySQL to PostgreSQL Huge redundant parts
Oracle and DB2, Comparison and Compatibility Huge redundant parts
Structured Query Language
Contents
Introduction
Data structure definition
Data types
Numeric types
Character types
Date and time types
Binary types
Large object types
Misc types
Delimited identifiers
Auto-increment column
Functions and expressions
Math functions
Trigonometric functions
Numeric functions
Aggregate functions
Date and time functions
String functions
Misc expressions
Select queries
Subqueries
Select without tables
Limiting results of select query
Hierarchical Queries
Write queries
Replace query
Insert results from select query into existing table
Save results from select query as new table
Update returning
/Transactions/
Procedural language
Stored procedures
User-defined functions (UDFs)
/SQL XML/
/Administration/
/References/
See also
https://www.virtualbox.org/svn/vbox/trunk/src/VBox/ValidationKit/testmanager/db/TestManagerDatabase/types.xml
SQL
S
75%
__NOTOC__ __NOEDITSECTION__