Answer Posted / deepak_shr
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 |
Post New Answer View All Answers
What is instead of trigger sql server?
what's the information that can be stored inside a bit column? : Sql server database administration
How to add more data to the testing table in ms sql server?
What is dbcc updateusage?
How to create a large table with random data for index testing in ms sql server?
what are constraints? Explain different types of constraints? : Sql server database administration
How can I create a report based on a query? : sql server management studio
How to return the top 5 rows from a select query in ms sql server?
What are the pre-defined functions in the sql server?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are database states in ms sql server?
How to remove duplicate rows from table except one?
Explain an incremental backup?
Explain the microsoft sql server delete command? : SQL Server Architecture
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
