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
What is temporary table in sql server? Why we use temp table?
How can I create a report based on a query? : sql server management studio
Equi join and non equi join is possible with sql server?
Explain what are the different index configurations a table can have?
What is Dependency Injection and provide example?
what are the types of indexes? : Sql server database administration
How does stuff differ from the replace function?
How do I edit a procedure in sql server?
Describe in brief authentication modes in sql server.
can any body tell me how to know the password of current user in sql server
What do you mean by subquery?
Explain the dirty pages?
What are the types of containers in ssis?
where the connection string store in the database
Can we write ddl in trigger?
