Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain about SQL server 2005?
How can we determine what objects a user-defined function depends upon?
Differentiate between mongodb vs. Sql server?
What are number line correlation administrators will use while working with a subquery?
In what version of sql server were synonyms released?
When I run the sql server 2000 setup, it just hangs. What do I do?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What are click through reports?
What are page splits?
Why the trigger fires multiple times in single login?
What is 2nf normalization?
Can we use trigger new in before insert?
How you can find out if an index is useful to the optimizer?
How to find the version of sql server? : sql server database administration
Can two tables have the same primary key?
