Home > DeveloperSection > Interviews > What is CTE?

Posted on    May-11-2011 5:15 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  1251  View(s)
Rate this:

Awadhendra Tiwari

Total Post:510

Points:2550
Posted on    May-11-2011 12:00 AM

CTE is an abbreviation Common Table Expression. A Common Table Expression (CTE) is an expression that can be thought of as a temporary result set which is defined within the execution of a single SQL 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.

Don't want to miss updates? Please click the below button!

Follow MindStick