Use of 2 group functions?

[vbkris]

hi,

when i use this it gives me an error:

select max(avg(field1)).....

is there a better way to pick the data. i am forced to use MySql 3.x version (cause thats whats there on the server!!!)

Known is handfull, Unknown is worldfull

 

[TonyGroves]

You would have to first get the AVG() results, store them in a temporary table, then get the MAX():
[tt]
CREATE TEMPORARY TABLE t AS
SELECT AVG(field1) a FROM tbl1;
SELECT MAX(a) m FROM t;
[/tt]

 

[TonyGroves]

Of course, the AVG() query would have to grouped:
[tt]
CREATE TEMPORARY TABLE t AS
SELECT AVG(field1) a
FROM tbl1
GROUP BY field2;
SELECT MAX(a) m FROM t;
[/tt]

 

[vbkris]

thanks buddy...

Known is handfull, Unknown is worldfull