Hello.

I'm getting the wonderful 1111 error on this query: Invalid use of
group function. I'm a bit confused as to how to fix it. Any ideas?

Select user_name, MIN(score) FROM Game
WHERE config_name = 'Graph1Puzzle1' AND end_status = 'SOLVED'
GROUP BY user_name
ORDER BY MIN(score) ASC
LIMIT 50

Evan wrote:
> Hello.
>
> I'm getting the wonderful 1111 error on this query: Invalid use of
> group function. I'm a bit confused as to how to fix it. Any ideas?
>
> Select user_name, MIN(score) FROM Game
> WHERE config_name = 'Graph1Puzzle1' AND end_status = 'SOLVED'
> GROUP BY user_name
> ORDER BY MIN(score) ASC
> LIMIT 50


What version are you using?


mysql> select * from a;
+-------+------+------+
| a | b | c |
+-------+------+------+
| user1 | 10 | 4 |
| user1 | 20 | 4 |
| user1 | 10 | 4 |
| user2 | 10 | 4 |
| user2 | 20 | 4 |
+-------+------+------+
5 rows in set (0.00 sec)

mysql> select a, min(b) from a where c = 4 group by a order by min(a)
desc limit 2;
+-------+--------+
| a | min(b) |
+-------+--------+
| user2 | 10 |
| user1 | 10 |
+-------+--------+
2 rows in set (0.00 sec)

On Apr 2, 10:56pm, Michael Austin <maus...@firstdbasource.com> wrote:

> What version are you using?


4.1.10a

On Apr 3, 8:49am, Evan <evanp...@gmail.com> wrote:
> On Apr 2, 10:56pm, Michael Austin <maus...@firstdbasource.com> wrote:
>
> > What version are you using?
>
> 4.1.10a

I may have figured it out. I removed the MIN function from ORDER BY
MIN(score).
It seems to be working fine.