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
Moderator: General Moderators
Code: Select all
select distinct max(round_num),del_id from delivery where region_id=018 group by round_numCode: Select all
select max(round_num),del_id from delivery where region_id=018 group by round_numCode: Select all
select max(round_num) from delivery