MariaDB

Selecting Data

The SELECT statement is used for retrieving data from tables, for select specific data, often based on a criteria given in the WHERE clause.

• SELECTSQL statement used primarily for retrieving data from a MariaDB database.

• Joins & SubqueriesDocumentation on the JOIN, UNION, EXCEPT and INTERSECT clauses, and on subqueries.

• LIMITDocumentation of the LIMIT clause.

• ORDER BYOrder the results returned from a resultset.

• GROUP BYAggregate data in a SELECT statement with the GROUP BY clause.

• Common Table ExpressionsCommon table expressions are temporary named result sets.

• SELECT WITH ROLLUPAdds extra rows to the resultset that represent super-aggregate summaries

• Optimizer HintsOptimizer hints There are some options available in SELECT to affect the ex…

• PROCEDUREThe PROCEDURE Clause of the SELECT Statement.