6 ms·
The topic of CTEs was recently discussed (with much vigor) on the SQLite users mailing list: https://www.mail-archive.com/sqlite-users@sqlite.org/msg81199.html
by seanwoods 13y ago
The topic of CTEs was recently discussed (with much vigor) on the SQLite users mailing list:
https://www.mail-archive.com/sqlite-users@sqlite.org/msg81199.html https://www.mail-archive.com/sqlite-users@sqlite.org/msg8119...
- fphhotchips 13y ago"as long as the 'RECURSIVE' part of CTE is ignored."... To me, the recursive part of CTEs is half the point! All the other stuff is syntactic sugar that can be done elsewhere, but recursion is a function that I'm unable to find another method for elsewhere in the language. Note: I have far more SQL Server experience than I do with any other DBMS.