Bug #60940 Implement Common Table Expressions as defined by the ANSI SQL 99 standard
Submitted: 21 Apr 2011 3:56 Modified: 21 Apr 2011 7:28
Reporter: Behrang Saeedzadeh Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: General Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: common table expressions, cte, with

[21 Apr 2011 3:56] Behrang Saeedzadeh
From Wikipedia:

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.

[At the moment,] common table expressions are supported by DB2, Firebird, Microsoft SQL Server, Oracle, PostgreSQL and H2.

How to repeat:
Feature request. N/A.+
[21 Apr 2011 7:28] Valeriy Kravchuk
This is a duplicate of Bug #16244.