MySQL

SELECT API Reference

MySQL SELECT statement clauses for querying and combining rows from one or more tables.

By EZ4Code TeamLast updated: 2026-08-01

SELECT

Clauses available within a SELECT statement.

SELECT cols FROM tbl [WHERE condition]

Reads rows from a table, optionally filtered by a boolean condition.

Returns: ResultSet

SELECT ... FROM a JOIN b ON a.id = b.a_id

Combines rows from two tables based on a join predicate; INNER, LEFT, RIGHT, FULL supported.

Returns: ResultSet

SELECT cols, agg(...) FROM tbl GROUP BY cols [HAVING condition]

Groups rows by the listed columns and applies aggregate functions, filtering groups with HAVING.

Returns: ResultSet

SELECT ... ORDER BY col [ASC|DESC] [LIMIT n [OFFSET m]]

Sorts the result set by the given columns and limits the number of rows returned.

Returns: ResultSet