4 ms·
I think the problem here is with the query, not the language. You can immediately improve its maintainability and readability by using CTEs. https://antonz.org
by nalgeon 3y ago
I think the problem here is with the query, not the language. You can immediately improve its maintainability and readability by using CTEs.
https://antonz.org/cte/ https://antonz.org/cte/
- rjbwork 3y agoThis exactly the comment I was going to leave. If I get past one sub query, I will refactor to CTE.
- dan-robertson 3y agoMaintainability is not relevant to ad-hoc analytics queries. That may be dealt with once the correct query has been determined from sufficient iteration.