What is CTE?

What is CTE?

CTE is stands for Common Table Expression. It is like to a derived table in that it is not stored as an object and lasts only for the duration of the query. A Common Table Expression CTE) is a type of  expression that can be seem like as a temporary result set which is explain within the execution of a single SQL statement. 

Date:2012-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher