On Apr 23, 2014, at 12:16 AM, Dominique Devienne <[email protected]> wrote:
> is there no way to reuse a CTE several times? Hrm… of course you can… that’s the entire point of *Common* Table Expression: with DataSet as ( select 1 as value ) select * from DataSet union all select * from DataSet; _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
