Answers for "common table expression sql"

CTE statement sql server

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

what is common table expression in sql

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