Outils pour utilisateurs

Outils du site


glossaire:cte

CTE

A Common Table Expression, or CTE, (in SQL) is a temporary named result set, derived from a simple query and defined within the execution scope of a SELECT, INSERT, UPDATE, or DELETE statement.

CTEs can be thought of as alternatives to derived tables (subquery), views, and inline user-defined functions.

glossaire/cte.txt · Dernière modification: 19/05/2012 00:18 (modification externe)