1 of 1

Precedence Control in Table Operations

Control the execution order of UNION, EXCEPT, and INTERSECT operations. Learn how to use parentheses to define explicit operation priority.

You can control the ordering of execution on table operations using parentheses.

Syntax

(  expression )
[ORDER BY [column[, column...]]]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]

Description

Using parentheses in SQL allows to control the order of execution for statements and , including , , and operations. MariaDB executes the parenthetical expression before the rest of the statement. You can then use and clauses the further organize the result set.

The Optimizer may rearrange the exact order in which MariaDB executes different parts of the statement. When it calculates the result set, however, it returns values as though the parenthetical expression were executed first.

Example

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