SQL Query keywords
B
BETWEEN
The SQL BETWEEN operator filters values within a range (inclusive).
D
DISTINCT
The SQL DISTINCT keyword removes duplicate rows from a result set.
E
EXISTS
The SQL EXISTS operator checks whether a subquery returns any rows.
I
ILIKE
The SQL ILIKE operator performs a case-insensitive pattern match (PostgreSQL only).
IN
The SQL IN operator checks whether a value matches any value in a list or subquery.
L
LIKE
The SQL LIKE operator searches for a specified pattern in a column.
LIMIT
The SQL LIMIT clause restricts the number of returned rows.
O
OFFSET
The SQL OFFSET clause skips a number of rows before returning results.
ORDER BY
The SQL ORDER BY clause sorts query results.
S
SELECT
The SQL SELECT statement is used to retrieve data from one or more tables.
W
WHERE
The SQL WHERE clause filters rows based on conditions.