---

Search posts under SQL Server:

---

SQL Server > Common Table Expression (CTE)

In this section we are going to learn about the Common Table Expression (CTE) in SQL server.

Common Table Expression (CTE)

Common table expression is a temporary result set that we define during the execution of the SQL statements. The CTE is a run time object whose scope is limited to the execution of the query just after the CTE is defined. Generally, it is used to replace views, perform recursion, creating multiple reference of the single table data or hold temporary data.

Read posts under SQL Server > Common Table Expression (CTE)

1. Create a CTE (Common Table Expression)