On 26 Dec 2013, at 3:27pm, big stone <stonebi...@gmail.com> wrote: > Does SQLite plan to implement soon a "Common Table Expression" subset ?
Common Table Expressions are implemented as sub-SELECTs, as documented in the 'select-stmt' part of this page: <http://www.sqlite.org/lang_select.html> You can do things like this: SELECT * FROM company WHERE id IN ( SELECT company FROM wages WHERE salary > 45000); and this: SELECT sb1,sb2,sb3 FROM (SELECT s1 AS sb1, s2 AS sb2, s3*2 AS sb3 FROM t1) AS sb WHERE sb1 > 1; The implementation is the same as that used in MySQL, allowing for other differences between the two engines. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
