SQL question
Posted in 1996
rickt — — source: Informix-list mailing list archive (1991-1998)
If I have the following SQL
select column1, count(*) from tablefoo
group by column1
It returns 24 rows with various counts.
Is there a way to return just the number of rows that would have been
returned. (ie just the number 24)
I know I could put it in a temp table and then count that but, yuk
--
Rick Tucker
rickt@wybbs.wynalda.com
-- I try to take one day at a time..., but lately several days
have attacked me at once. --