What is CTE and its example
CTE stands for Common Table Expression, use Dr. Google for more specifications. According to me CTE means a temp view/table to hold any query result. Its very useful in writing complex recursive queries. click to see . Here I am demonstrating a small example of CTE. Suppose, You have a table M_Users , see below :- M_Users Username FirstName admin Gagan uAman Aman uNaman Naman now execute following query :- ;WITH ExampleCTE(Username,FirstName) AS ( SELECT Username, firstname from M_Users ) SELECT * FROM ExampleCTE Output : ExampleCTE Username FirstName admin Gagan uAman Aman uNaman Naman Output is quite simple, here you can write multiple queries defining joins and all. depends upon your requirement.