Give an example of CTE?

 Posted by vishalneeraj-24503 on 7/1/2014 | Category: Sql Server Interview questions | Views: 314 | Points: 40
Answer:

Following is a very simple example of CTE as:-
With CTE_Employee_Master

As
(
Select * From Employee_Master;
)

;With CTE_Employee_Master(Emp_Id,Employe_Name,Pan_Number)
As
(
Select Emp_Id,Employe_Name,Pan_Number From Employee_Master;
)


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response