help needed with SELECt and max value

[pelegk2]

is there any way to ask for a max number :
Code:

select distinct max(round_num),del_id from delivery where region_id=018 group by round_num

in this case i recive 2 max(round_num) (1 and 2 ) for the "where region_id=018 "
how can i make it so i will gt only the 1 that is realy maximux?
thnaks in advance
peleg

[onion2k]

You need to group by the region_id, not the round_num.

[pelegk2]

can u explain why?