codint codp qta
10 2 4
10 1 6
20 2 10
30 1 12
40 2 12
20 5 5
--- ---
SELECT codint, sum(qta) as somma FROM `usa` group by codint codint somma
10 10
20 15
30 12
40 12
--- ---
create temporary table tempo as SELECT codint, sum(qta) as somma FROM `usa`
group by codint;
select codint,somma from
(SELECT codint, sum(qta) as somma FROM `usa` group by codint) as temp1 where somma = (select max(somma)as max from tempo);
codint somma
20 15
--- ---
Invece la query seguente dà un risultato ma non è corretto!!
select codint, max(somma)as max from (SELECT codint, sum(qta) as somma FROM
`usa` group by codint) as temp1
codint somma
10 15