MAX and MIN

[JoSno]

Hello everyone,

Simple question (I think) that I can't find a definitive answer for. Basically I'm trying to compare some max and min values against explicit values, ie.

SELET ....., max(working_time), min(working_time)
FROM tableA
WHERE ....
AND MAX(working_time) < &quot;1200&quot;
GROUP BY tableA.key;

It reports &quot;ERROR 1111: Invalid use of group function&quot;.

Now I the comparison aorks if I just take an explicit row and compare WHERE working_time < &quot;1200&quot; so it's not a invalid comparison of integer against string or anything like that.

I'm running Linux MySQL version 3.23.53a

Cheers
Jo

 

[swampBoogie]

SELET ....., max(working_time), min(working_time)
FROM tableA
WHERE ....
GROUP BY tableA.key
having MAX(working_time) < '1200'