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
Detail about query optimizer?
What is query and its types?
What does set rowcount do?
How to insert multiple rows with a subquery?
Explain the etl (extraction, transformation, and loading)?
In which sql server version report builder introduced?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Do you know what are acid properties?
What are the restrictions applicable while creating views? : SQL Server Architecture
What are the types of dml?
What is difference between foreign key and unique key?
Why would you call update statistics?
What happens if strings are casted into wrong code pages in ms sql server?
How to convert a unicode strings to non-unicode strings?
How to verify a login name with sqlcmd tool?
