what are CTE? When and Why To Use CTE in SQL ?

What are CTE in SQL ? CTE are Common Table Expressions first introduced in Sql Server 2005. It is basically a result set or result holder or separate plugin / extension that can hold some complex query separately from main query and supply the named result set or result holder name in place of that complex query in main query. It really improves complexity of complex queries....