help needed with SELECt and max value
Posted: Tue Dec 21, 2004 7:32 am
is there any way to ask for a max number :
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
Code: Select all
select distinct max(round_num),del_id from delivery where region_id=018 group by round_numhow can i make it so i will gt only the 1 that is realy maximux?
thnaks in advance
peleg