This repository was archived by the owner on Aug 11, 2023. It is now read-only.

SQL

Structured Query Language

RDBMS

Relational Database Management System

SQL Commands

Database

CREATE

Table

CREATE
DROP
ALTER
INSERT
- INTO
SELECT
UPDATE
DELETE
ORDER BY
- ASC, DESC
WHERE
- LIKE, BETWEEN, IN, IS, AND, OR, NOT, NULL, =, <>, >, <, >=, <=
IF
EXISTS
DISTINCT
LIMIT
Functions
- min, avg, max, count, sum, mod, ceil, round, abs, floor, sign
- concat, trim, upper, lower, length,
- least, greatest
Date Functions
- date_trunc, extract

JOIN
CONSTRAINT
GRANT