Tim Streater wrote: > select count(*),x,y,z from sometable where …; > > or is that a bad idea?
An aggregate function prevents you from getting the individual records: sqlite> create table sometable(x,y,z); sqlite> insert into sometable values (1,2,3), (4,5,6); sqlite> select count(*),x,y,z from sometable; 2|4|5|6 You could use UNION ALL to put the count into the first record: sqlite> select count(*),null,null from sometable union all select x,y,z from sometable; 2|| 1|2|3 4|5|6 ... but then you could just as well use a separate query. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
