Hu,
> SELECT MAX(COUNT(*))
That makes no sense. COUNT(*) will list the number of rows in your
table, whereas MAX(column) will list the hightest value of in
your table, like that:
mysql> SELECT COUNT(*) FROM t;
+--+
| COUNT(*) |
+--+
|4 |
+--+
1 row in set (0.00 s
uesday, March 25, 2003 16:03
Subject: embedded group function
> All,
>
> I tried to use
> SELECT MAX(COUNT(*))
> FROM ...
> GROUP BY ...
>
> in MySQL. But an error occured: Invalid use of group function.
>
> Is it necessary to create a temporary table to stor
All,
I tried to use
SELECT MAX(COUNT(*))
FROM ...
GROUP BY ...
in MySQL. But an error occured: Invalid use of group function.
Is it necessary to create a temporary table to store the COUNT(*) results, and then
get the MAX from it?