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.

Title Description
SELECT SQL statement used primarily for retrieving data from a MariaDB database.
Joins & Subqueries Documentation on the JOIN, UNION, EXCEPT and INTERSECT clauses, and on subqueries.
LIMIT Documentation of the LIMIT clause.
ORDER BY Order the results returned from a resultset.
GROUP BY Aggregate data in a SELECT statement with the GROUP BY clause.
Common Table Expressions Common table expressions are temporary named result sets
SELECT WITH ROLLUP Adds extra rows to the resultset that represent super-aggregate summaries
SELECT INTO OUTFILE Write the resultset to a formatted file
SELECT INTO DUMPFILE Write a binary string into file
FOR UPDATE Acquires a lock on the rows
LOCK IN SHARE MODE Acquires a write lock
Optimizer Hints Optimizer hints There are some options available in SELECT to affect the ex...
PROCEDURE The PROCEDURE Clause of the SELECT Statement.
HANDLER Direct access to reading rows from the storage engine.
DUAL Dummy table name
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.