Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

Expert SEQUEL

Name: Anonymous 2011-02-20 3:02

 create temp table temp_table(i integer);

 insert into temp_table select count() from data group by entity having count() < 10;

 select count() from temp_table;

This is obnoxious, any way to count the number of rows returned by a select statement without using a temp table?

Name: Anonymous 2011-02-20 21:50

>>6
Oh, so that's the fucking syntax. Thanks. _{_{_{_{I did try to put the subquery inside count(), as well as some other stupid shit.}}}}

The second form seems too good to be true, and indeed it is, at least for sqlite.

Newer Posts

Expert SEQUEL

1 Name: Anonymous 2011-02-20 3:02

7 Name: Anonymous 2011-02-20 21:50

Name: Anonymous 2011-02-20 3:02

Name: Anonymous 2011-02-20 21:50