CTE(common table expression)
A common table expression (CTE) is a temporary result set
that is defined within the execution scope of a single
SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A
CTE is similar to a derived table in that it is not stored
as an object and lasts only for the duration of the query.
Unlike a derived table, a CTE can be self-referencing and
can be referenced multiple times in the same query.
A CTE can be used to:
1. Create a recursive query.
2. Substitute for a view when the general use of a view is
not required; that is, you do not have to store the
definition in metadata.
3. Reference the resulting table multiple times in the same
statement.
4. Enable grouping by a column that is derived from a scalar
subselect, or a function that is either not deterministic or
has external access.
Is This Answer Correct ? | 9 Yes | 0 No |
What are the diifferences between the ms sql server vs mysql?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
i want table name basis on column name.
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is a transact-sql statement batch in ms sql server?
How get current date in SQL server 2000
How many types of local tables are there in sql server?
How to rebuild indexes with alter index ... Rebuild?
What do you mean by sql server agent?
how to find maximum identity number in a table ?
2 Answers JPMorgan Chase, Thomson Reuters, Wipro,
What are the steps you must follow to hide sql server instances?
What is normalization? Explain different forms of normalization?