> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/selecting-data.md).

# Selecting Data

Learn to select data in MariaDB Server using SQL. This section covers various SELECT statement clauses, including WHERE, GROUP BY, and ORDER BY, to retrieve and filter your data effectively.

* [DUAL](/docs/server/reference/sql-statements/data-manipulation/selecting-data/dual.md)
* [FOR UPDATE](/docs/server/reference/sql-statements/data-manipulation/selecting-data/for-update.md)
* [GROUP BY](/docs/server/reference/sql-statements/data-manipulation/selecting-data/group-by.md)
* [LIMIT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/limit.md)
* [LOCK IN SHARE MODE](/docs/server/reference/sql-statements/data-manipulation/selecting-data/lock-in-share-mode.md)
* [Optimizer Hints](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints.md)
* [ORDER BY](/docs/server/reference/sql-statements/data-manipulation/selecting-data/order-by.md)
* [PROCEDURE](/docs/server/reference/sql-statements/data-manipulation/selecting-data/procedure.md)
* [SELECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md)
* [SELECT INTO DUMPFILE](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select-into-dumpfile.md)
* [SELECT INTO OUTFILE](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select-into-outfile.md)
* [SELECT ... OFFSET ... FETCH](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select-offset-fetch.md)
* [SELECT WITH ROLLUP](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select-with-rollup.md)
* [Common Table Expressions (CTE)](/docs/server/reference/sql-statements/data-manipulation/selecting-data/common-table-expressions.md)
* [Joins](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins.md)
* [Set Operations](/docs/server/reference/sql-statements/data-manipulation/selecting-data/set-operations.md)
* [Subqueries](/docs/server/reference/sql-statements/data-manipulation/selecting-data/subqueries.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>