Back to Cheatsheets
SQL Basics
Fundamental SQL queries.
DDL
CREATE TABLECreate Table
Define new table.
Copied!
DROP TABLEDelete Table
Remove table completely.
Copied!
ALTER TABLEModify Table
Change table structure.
Copied!
DML
SELECTRead Data
Copied!
INSERT INTOAdd Data
Copied!
UPDATEModify Data
Copied!
DELETERemove Data
Copied!
Clauses
WHEREFilter
Copied!
ORDER BYSort
Copied!
GROUP BYGroup
Copied!
HAVINGFilter Group
Copied!