CTE

Question

When CTE use in real world and How?

Shubham Kumar · Answer

Hi Ramya some time we are unable to join the table based on their datameans when we making join on table we are not able to find appropiate result set we got repeated data or not concurrent data so that time we have to need some filter data. o0n based of filter data we make join or else things basically cte (common table expression) give us ability to join two or more result set (I am telling about result set not table) see for more details http://blog.sqlauthority.com/2011/05/10/sql-server-common-table-expression-cte-and-few-observation/

Manish Kumar · Answer

The best part of CTE is recursive. In this you can find parent and child relationship with in single table