Citat:
Originalno napisao jablan
select top 1 idlica, sum(proizvod3)
from proizvod
where sifraprodavnice = @sifraprodavnice
group by idlica
order by sum(proizvod3) desc
|
dodaj i LIMIT 1 na kraj, jer te zanima samo taj jedan record...
__________________
Leadership is the art of getting people to want to do what you know must be done.
Poslednja izmena od ivanhoe : 24. 06. 2007. u 23:45.
|