Common Table Expressions (CTE) Example In SQL SERVER

A common table expression i.e CTE which is used to the specific temporary result set by using SELECT, INSERT, UPDATE, or DELETE statement. So the user can do further operations on it. When the user uses joins queries on some particular table & in sub-queries, he needs the same set of records then code readability is slightly difficult, so use of CTE is makes code readability makes better.

source https://www.c-sharpcorner.com/article/common-table-expressionscte-example-in-sql-server2/