SELECT
1
| SELECT Column_Name FROM Table_Name
|
SELECT * FROM Table_Name
SELECT DISTINCT Column_Name FROM Table_Name
SELECT DISTINCT Column_Name FROM Table_Name
SELECT Column_Name FROM Table_Name LIMIT Number
SELECT Column_Name FROM Table_Name LIMIT Number
SELECT Function(Column_Name) FROM Table_Name
- avg()
- count()
- first()
- last()
- max()
- min()
- sum()
Prerequisite
SELECT Column_Name FROM Table_Name WHERE Condition
Option |
Description |
|---|
>,<,>=,<= |
larger/smaller than a specific value |
=,!= |
equal or unequal to a specific value |
BETWEEN |
in a certain range |
LIKE |
search in a certain area, always combined with wildcard |
Sort
SELECT Column_Name FROM Table_Name ORDER BY Column_Name
Alias
SELECT Column_Name AS Alias FROM Table_Name
SELECT Column_Name FROM Table_A_Name AS A JOIN Table_B_Name AS B
