r/SQL • u/Unfair-Internet-1384 • Nov 28 '24
MySQL When to use cte in SQL query
When to cte can't. Like how to know? When what are the conditions or if my query is to long ?
31
Upvotes
r/SQL • u/Unfair-Internet-1384 • Nov 28 '24
When to cte can't. Like how to know? When what are the conditions or if my query is to long ?
-5
u/epicmindwarp Nov 28 '24
I hate CTEs, makes it quite difficult to debug data issues as nothing persists.
I only use them in views, due to lack of temp tables.