The SELECT statement

The SELECT-FROM statement

SELECT column_name, ...
FROM table_name;

The SELECT-FROM-WHERE statement

SELECT *
FROM table_name
WHERE condition;

The SELECT-FROM-WHERE statement with AND keyword

SELECT *
FROM table_name
WHERE condition;

The SELECT-FROM-WHERE statement with OR keyword

SELECT *
FROM table_name
WHERE condition_1 OR condition_2;

The SELECT-FROM-WHERE statement with IN/NOT IN keywords

-- IN keyword 
SELECT *
FROM table_name
WHERE column_name IN (value_1, value_2,...);

-- NOT IN keyword 
SELECT *
FROM table_name
WHERE column_name NOT IN (value_1, value_2,...);

The SELECT-FROM-WHERE statement with LIKE/NOT LIKE keywords

-- LIKE keyword 
SELECT *
FROM table_name
WHERE column_name LIKE ('_value%');

-- NOT LIKE keyword 
SELECT *
FROM table_name
WHERE column_name NOT LIKE ('_value%');

The SELECT-FROM-WHERE statement with BETWEEN-AND keywords

SELECT * 
FROM table_name
WHERE column_name BETWEEN value_1 AND value_2;

The SELECT-FROM-WHERE statement with IS NULL/IS NOT NULL keywords

-- IS NULL keyword 
SELECT * 
FROM table_name
WHERE column_name IS NULL;

-- IS NOT NULL keyword
SELECT *
FROM table_name
WHERE column_name IS NOT NULL;

The SELECT DISTINCT - FROM statement

SELECT DISTINCT column_name
FROM table_name;

The SELECT-FROM-ORDER BY statement

SELECT *
FROM table_name
ORDER BY column_name [ASC/DESC];

The SELECT-FROM-GROUP BY statement

SELECT column_name, COUNT(column_name)
FROM table_name
GROUP BY column_name;

The SELECT-FROM-GROUP BY-HAVING statement

SELECT * 
FROM table_name
GROUP BY column_name
HAVING condition;

The SELECT-FROM-LIMIT statement

SELECT *
FROM table_name
LIMIT number_of_rows;