CTE stands for Common Table expressions. These are simple select queries and they do not create physical space in tempDB. Unlike temporary table there life is limited to the current query. This is ...