common table expressions sql code example

Example 1: CTE statement sql server

WITH Employee_CTE (EmployeeNumber, Title)
AS
(SELECT NationalIDNumber,
        JobTitle
 FROM   HumanResources.Employee)
SELECT EmployeeNumber,
       Title
FROM   Employee_CTE

Example 2: what is common table expression in sql

CTE generates a temporary result that will further 
be used by select, update, delete.