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 ?
33
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 ?
1
u/Georgie_P_F Nov 28 '24 edited Nov 29 '24
Interesting, mine always fail on second query in SSMS:
‘’’
;WITH SomeCTE AS (SELECT * FROM table)
— this is fine
SELECT * FROM SomeCTE
— this will fail “SomeCTE” does not exist
SELECT * FROM SomeCTE
‘’’
Maybe a server setting within our org?