Emanuel
Emanuel

Reputation: 6972

MySql Group function error

select nume,model,sum(km_sosire-km_plecare) as 'km_parcursi' from masina m
inner join (foaie_parcurs f inner join angajat a using(id_angajat)) using(id_masina)
where sum(km_sosire-km_plecare)>100
group by a.nume,m.model
order by sum(km_sosire-km_plecare);

Error: Invalid use of group function

Why?

Thanks.

Upvotes: 0

Views: 168

Answers (1)

Willis Blackburn
Willis Blackburn

Reputation: 8204

You can't use aggregates in the where clause. That's what "having" is for.

select nume,model,sum(km_sosire-km_plecare) as 'km_parcursi' from masina m
inner join (foaie_parcurs f inner join angajat a using(id_angajat)) using(id_masina)
group by a.nume,m.model
having sum(km_sosire-km_plecare)>100
order by sum(km_sosire-km_plecare);

Upvotes: 4

Related Questions