If you don't want a group count, but want a total row count instead, there's
no reason to have the group by statement, If you're trying to have a
conglomerate result, where one column is always equal to the total count,
wouldn't it be more efficient to have a seperate query for that?
-Micah
El Dom 26 Jun 2005 07:39, Ross Honniball escribió:
Hi All,
I use
SELECT COUNT(*) FROM whatever WHERE whatever
to determine how many rows a particular query will return (then use this
count to assist with pagination).
The problem is that this does not work if the query contains a
It worked!
SELECT COUNT(*) FROM (SELECT COUNT(*) FROM ad.off_enrol GROUP BY
jcu_campus, sub_code) t1
Thank you list -:)
Martín Marqués wrote:
El Dom 26 Jun 2005 07:39, Ross Honniball escribió:
Hi All,
I use
SELECT COUNT(*) FROM whatever WHERE whatever
to determine how many rows a