SELECT a.* from nd_tracking_file a , (SELECT max(id) as id from nd_tracking_file
group by bl,container_number ORDER BY id ASC)b where a.id = b.id
去重字段 bl,container_number
SELECT a.* from nd_tracking_file a , (SELECT max(id) as id from nd_tracking_file
group by bl,container_number ORDER BY id ASC)b where a.id = b.id
去重字段 bl,container_number