Category: SQL

Filter inclusive ranges with BETWEEN … AND ….

Match values against a list with IN / NOT IN.

Restrict result size with LIMIT (MySQL/PostgreSQL style).

Skip rows for pagination with OFFSET.

Change existing rows with UPDATE … SET … WHERE.

Remove rows with DELETE FROM … WHERE.

Compare values with =, , , =.

Combine conditions with AND, OR, and NOT.

Quickly remove all rows while keeping table structure.

Add rows with INSERT INTO … VALUES / SELECT.