On 24 November 2010 11:08, Swithun Crowe <[email protected]> wrote: > Hello > > BS> Thanks, I tried that and it gives no error, but only gives the first > BS> lot, not the bit after the union all. > > Ah. I hadn't tried with data. I don't know why the LIMIT affects the UNION > ALL, when it is buried in a subquery.
It doesn't in version 3.7.0.1 sqlite> select sqlite_version(); 3.7.0.1 sqlite> sqlite> create table table1 (patientID int, age int); sqlite> insert into table1 (patientID, age) values (1, 50); sqlite> insert into table1 (patientID, age) values (2, 50); sqlite> insert into table1 (patientID, age) values (3, 50); sqlite> insert into table1 (patientID, age) values (4, 50); sqlite> insert into table1 (patientID, age) values (5, 50); sqlite> insert into table1 (patientID, age) values (6, 50); sqlite> insert into table1 (patientID, age) values (7, 50); sqlite> insert into table1 (patientID, age) values (8, 60); sqlite> insert into table1 (patientID, age) values (9, 60); sqlite> insert into table1 (patientID, age) values (10, 60); sqlite> insert into table1 (patientID, age) values (11, 60); sqlite> insert into table1 (patientID, age) values (12, 60); sqlite> sqlite> select patientID ...> from ( ...> select patientID ...> from table1 ...> where age = 50 ...> limit 6 ...> ) ...> union all ...> select patientID ...> from ( ...> select patientID ...> from table1 ...> where age = 60 ...> limit 4 ...> ); 1 2 3 4 5 6 8 9 10 11 sqlite> > > Swithun. Regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
