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

• FOR UPDATE

• GROUP BY

• LIMIT

• LOCK IN SHARE MODE

• Optimizer Hints

• ORDER BY

• PROCEDURE

• SELECT

• SELECT INTO DUMPFILE

• SELECT INTO OUTFILE

• SELECT ... OFFSET ... FETCH

• SELECT WITH ROLLUP

• Common Table Expressions (CTE)

• Joins

• Set Operations

• Subqueries

_{This page is licensed: CC BY-SA / Gnu FDL}