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?

>>7
Go here:
http://db.grussell.org/sql/interface.cgi?tn=Tutorial%201&qn=1

paste this in the text box:
select * from department;

select count(count(*))
from employee
group by depno
having count(*) > 5;

then press "Execute Query".

When I don't have access to a database and want to test a query, I usually adapt it and try it on that site. It runs an Oracle database, but I don't know what version.