Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Participant
778 Points
955 Posts
Jan 10, 2012 12:51 PM|LINK
what is CTE and what is the advantage. is there any advantage regarding performance of using CTE. it looks it is like temporary view.
WITH MyData AS ( select Specialist,jid from bbajobs ) select * from MyData
please discuss about CTE in detail
mou_inn
Participant
778 Points
955 Posts
regarding Common table expression CTE
Jan 10, 2012 12:51 PM|LINK
what is CTE and what is the advantage. is there any advantage regarding performance of using CTE. it looks it is like temporary view.
WITH MyData AS
(
select Specialist,jid from bbajobs
)
select * from MyData
please discuss about CTE in detail