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