What is the difference between CTE and temporary tables?

Related questions

1. What is cross join?
2. What is temporary table in mysql?
3. Can you use a CTE in a view?
4. Can we create index on CTE in SQL Server?
5. What is #table in SQL?
6. What are tables and fields in SQL?
7. What is the difference between a local and a global temporary table?
8. What is the difference between temporary table and table variable?
9. What does with do in SQL?
10. Can we use more than one CTE in a single select query?

Tags

1. #table
2. #statement
3. #create
4. #update
5. #query
6. #derived
7. #lasts
8. #duration
9. #scope
10. #probably
11. #biggest
12. #difference
13. #delete
14. #insert
15. #object
16. #between
17. #execution
18. #similar
19. #single
20. #stored
21. #select