Expert SEQUEL

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?

>>8
Okay but I'm not buying Oracle. Goddamn why isn't this fucking language properly standardized. A page to check at once in 3 or 4 DBMs would be awesome.

Heh, Oracle needs some argument to count(). Haven't looked into it deeply, but I got the impression count() should always return the same value for any column name you pass to it (unless you use distinct).