On 29 Jul 2015, at 11:32pm, Richard Hipp <drh at sqlite.org> wrote: > I'm looking for real-world (open-source) use cases for CTEs.
I would like to see a demonstration of how non-recursive CTEs can be useful in simplifying a SQL command. Ideally in a plausible example rather than something obviously made up with no real-world equivalent. It seems that everyone who mentions CTEs jumps straight to recursion, as if that's the only thing they're useful for. Simon.