2 ms·
How to use a CTE with a group of several following statements? I think this is where you would use a view instead, but would appreciate confirmation.
by mixmastamyk 4y ago
How to use a CTE with a group of several following statements? I think this is where you would use a view instead, but would appreciate confirmation.
- cafxx 4y agoFor complex SELECT queries, I do: WITH cte1 AS ( /* whatever / ), cte2 AS ( / you can refer to cte1 here / ), cte3 AS ( / you can refer to cte1 and cte2 here */ ), ... If I need access into multiple statements that I can't refactor into a single one, explicitly using temporary tables is a viable option (some engines implement CTEs and other operations using implicit temporary tables anyway). Otherwise, yes, views.