MySQL operation to get maximum sum function
P粉139351297
P粉139351297 2024-04-04 17:49:26
0
1
473

I'm trying to set the maximum number to "max" An error occurred:

Error code: 1111. Invalid use of group function 0.000 seconds

SELECT max(count(*)) as max
FROM ticket
group by fan_fan_id;

I'm not sure what the problem is here and I'd be happy to get some help here - and I need to fix it without the "limit 1" option

P粉139351297
P粉139351297

reply all(1)
P粉949267121

SQL does not allow nested aggregate functions like the example you have shown.

The parameters of aggregate functions must be scalar expressions, not aggregate expressions.

You can do what you want:

SELECT MAX(c) FROM (SELECT COUNT(*) AS c FROM ticket GROUP BY fan_fan_id) AS t;

Or another way is to sort by value in descending order and return only the first count:

SELECT COUNT(*) AS c FROM ticket GROUP BY fan_fan_id ORDER BY c DESC LIMIT 1;
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template