Bože no tak potom takto:
select id, max(kod) as kod, suma
from tabulka
group by id
výsledok bude :
"a" "1" "150"
"b" "2" "200"
"c" "10" "50"
Naozaj to zadanie popisuješ ako v pomocnej škole...
Bože no tak potom takto:
select id, max(kod) as kod, suma
from tabulka
group by id
výsledok bude :
"a" "1" "150"
"b" "2" "200"
"c" "10" "50"
Naozaj to zadanie popisuješ ako v pomocnej škole...