|
|
|
|
|
|
by cafxx
1372 days ago
|
|
|
For 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. |
|
|