DEV Community

[Comment from a deleted post]
Collapse
 
shivprasad_ss profile image
shivprasadshelgavkar

I use CTEs quite a lot.. cause when you are scrapping report from DWH, you won't be having write access to different database.. so you can't create tables to store data.. much easier option is CTE than subquery when you are extracting data from multiple tables and joining together.. if you use subquery, it gets very ugly and hell lot of difficult to do any changes afterwards.. hence I love CTEs