logoalt Hacker News

Normal_gaussian05/04/20251 replyview on HN

"I'm really not sure what motivated the author to create the CTE in the first place, as the final select seems to be essentially the identity function."

We're likely seeing a simplified example. All queries should be able to be embedded in a CTE without integrity loss.


Replies

zokier05/04/2025

I think CTE is red herring here, the problem is in the sub-query regardless if it's in CTE or not

show 1 reply