拥有重复记录的表中通过group函数获取TRACE表里最新一条的数据

SELECT b.* FROM H.TRACE b, (SELECT BUSINESS_ID, max(sort_num) maxNum FROM H.TRACE bit GROUP BY BUSINESS_ID) t
WHERE b.BUSINESS_ID = t.BUSINESS_ID AND b.SORT_NUM = t.maxNum