Loading

Common Table Expression in SQL Server

Rohatash Kumar

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 Employeein 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

1 Comment

Join the conversation! Your thoughts help the community grow.

Virender Thakur9y ago
Not understand. What are you trying to explain.