What does a Common Table Expression (CTE) provide?
- A A named temporary result set that makes complex queries readable
- B A permanent table
- C A database index
- D A stored procedure
Answer
A named temporary result set that makes complex queries readable
CTEs break a complex query into readable steps and can be recursive, which is how hierarchies are traversed in SQL.





