The SQL WITH clause was introduced by Oracle in the Oracle 9i release 2 database. The SQL WITH clause allows you to give a sub-query block a name (a . 8 thg 8, 2017 - [ WITH <common_table_expression> [ ,.n ] ] <common_table_expression>::= expression_name [ ( column_name [ ,.n ] ) ] AS . 23 thg 9, 2012 - 2 Answers. The SQL WITH clause was introduced by Oracle in the Oracle 9i release 2 database. The SQL WITH clause allows you to give a sub-query block a name (a process also called sub-query refactoring), which can be referenced in several places within the main SQL query. The WITH clause adds named subqueries to SQL queries. WITH is also known as Common Table Expression (CTE). SQL AS Keyword. ❮ SQL Keywords Reference. AS. The AS command is used to rename a column or table with an alias. An alias only exists for the duration of . SQL aliases are used to give a table, or a column in a table, a temporary name. Aliases are often used to make column names more readable. An alias only . Starting in Oracle9i release 2 we saw an incorporation of the SQL-99 WITH clause (a.k.a. subquery factoring), a tool for materializing subqueries to save Oracle . So WITH syntax is like using temp variable or inline view where you can organize complex queries. To make queries reusable, SQL added views which can be . Common Table Expressions or CTE's for short are used within SQL Server to simplify complex joins and subqueries, and to provide a means to query .