Basic Query

Basic Query · Basic

SELECT

Selects the columns or expressions returned by a query.

Basic Query · Basic

WHERE

Filters rows so only records matching a condition are returned.

Basic Query · Basic

ORDER BY

Sorts query results by one or more columns.

Basic Query · Basic

LIMIT

Limits how many rows a query returns.

Basic Query · Basic

LIKE

Matches text patterns using wildcards.

Basic Query · Basic

DISTINCT

Removes duplicate rows from the query result.

Basic Query · Basic

BETWEEN

filtering values within a range

Basic Query · Basic

OFFSET

skipping rows, often for pagination.

Basic Query · Basic

IS NULL

filtering NULL or non-NULL values

Basic Query · Basic

AND / OR

combining multiple conditions