> 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

* [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)