why we are using CTE?

https://www.essentialsql.com/introduction-common-table-expressions-ctes/

0

Hello

Well CTE is used as alternative of Subqueries or views

For more detail you can follow :

https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-server-cte-basics/

http://www.c-sharpcorner.com/UploadFile/af66b7/cte/

I hope it helps

Thanks

0

There are many advantages of CTE.

One benefit is that with the help of CTE, we can create recursive query.

Visit this for detailed explanation:https://stackoverflow.com/questions/4740748/when-to-use-common-table-expression-cte

+1