Select topic:

Snippets

:

SQL

SQL UNIQUE Constraint

unique-key primary-key constraints

SQL

COALESCE

General-Functions COALESCE IF-ELSEIF-ENDIF

SQL

SELECT ROWNUM example

SQL

SQL - ORDER BY Clause

ORDER-BY-clause

SQL

CREATE Table Example

CREATE-statement DESC-command

SQL

JOIN, CROSS JOIN, and INNER JOIN in MySQL

cross-join inner-join MySQL join on-clause

SQL

Phantom reads Example

phantom-read transactions isolation SQL-SERIALIZABLE

SQL

Character Sets and Collations in General

collation binary-collation character-sets case-insensitive-collation

SQL

Correlated subquery

sub-queries correlated-subquery synchronized-subquery

SQL

SQL Query Order of Operations

ORDER-BY-clause HAVING-clause queries FROM-clause order-of-operations GROUP-BY-clause WHERE-clause SELECT-clause

Loading rules...