SQL Common Table Expression (CTE)
SQL Server has a very powerful feature has
been added for the programmers' benefit: Common Table Expression (CTE).
Common Table Expressions, or CTE, are a new construct introduced in Microsoft
SQL Server 2005 that offer a more readable form of the derived table that can be
declared once and referenced multiple times in a query.
We have a simple table Employee in our database.
Example
;WITH EmployeeCTE
AS
( SELECT
[EmpID]
,[EmpName]
,[EmpSalary]
FROM [master].[dbo].[Employee]
WHERE [EmpSalary]>4000
)
SELECT * FROM EmployeeCTE
Now press F5 to execute.
Output
