Structured Query Language/Snippets

This page offers SQL examples concerning different topics. You can copy/past the examples according to your needs.

Data Types

 * More Details

Constraints

 * More Details

Foreign Key

 * More Details

Alter Table

 * More Details

Concerning columns.

Concerning complete table.

Drop Table

 * More Details

Basic Syntax

 * More Details

Case

 * More Details

Grouping

 * More Details

Join

 * More Details

Subquery

 * More Details

Set operations

 * More Details

Rollup/Cube

 * More Details

Window functions

 * More Details

Recursions

 * More Details

Insert

 * More Details

Update

 * More Details

Merge

 * More Details

Delete

 * More Details

Truncate

 * More Details