AVG and SUM query

[blewett]

hi folks
can't work that out

is there anything wrong with this code

Code:

SELECT id FROM tb_empire
WHERE (networth > AVG(networth));

if yes, point that out
thanks in advance -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[desilva]

You aren't defining how the group should be performed.

You are using a GROUP function like AVG() in the WHERE clause and you can't do this since the values in the WHERE clause has to be known in the beginning of processing the table.

-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[sylvestor]

Hey, this will do the job for you


select id
from tb_empire
where networth
> ( select avg(networth)
from tb_empire)


Glad to help you -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[foghorn]

Hi dude

Yes, upgrade your version of mysql and also read the sticky thread at the top of this forum telling you about your outdated version of mysql.

Regards
foghorn -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[adam]

It is always a good idea to post the actual error message.

Code:
select e1.networth
from tb_empire e1, tb_empire e2
group by e1.networth
having e1.networth > avg(e2.networth) -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --