> What are table expressions used for in SQL?

What are table expressions used for in SQL?

Posted at: 2014-12-18 
I think so, that is how I use CTEs. They prevent the need to duplicate a complex query inside of nested queries.