CTE(common table expression)



CTE(common table expression)..

Answer / 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

More SQL Server Interview Questions

What are the diifferences between the ms sql server vs mysql?

0 Answers  


Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  


i want table name basis on column name.

5 Answers  


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?

0 Answers  


What is a transact-sql statement batch in ms sql server?

0 Answers  






How get current date in SQL server 2000

6 Answers   Cap Gemini,


How many types of local tables are there in sql server?

0 Answers  


How to rebuild indexes with alter index ... Rebuild?

0 Answers  


What do you mean by sql server agent?

0 Answers  


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?

0 Answers  


What is normalization? Explain different forms of normalization?

0 Answers  


Categories