select EN_ROUTE_RTE_ID,max(code_sort) from rte_seg group by EN_ROUTE_RTE_ID order by EN_ROUTE_RTE_ID
转载于:https://www.cnblogs.com/weihongli/archive/2013/03/21/2972592.html
select EN_ROUTE_RTE_ID,max(code_sort) from rte_seg group by EN_ROUTE_RTE_ID order by EN_ROUTE_RTE_ID
转载于:https://www.cnblogs.com/weihongli/archive/2013/03/21/2972592.html