时间排序，去重复SQL语句

select * from(select distinct barcode,out_date, company_name,company_no,in_date,employee_name,addresser_name,send_address,addresser_phone
    from (SELECT a.barcode,b.company_name,a.company_no,a.in_date,d.employee_name,a.addresser_name,a.send_address,a.addresser_phone,c.out_date FROM post_info a
 Left join express_company_info b on a.company_no = b.express_company_no
 left join post_out_info c on c.barcode=a.barcode
 left join employee_info d on d.employee_job_no=c.employee_no 
 WHERE  a.post_state in ('10','11','12') and a.postal_no = 'BJBSD00001'  ) as tb
 WHERE out_date in(select max(out_date) from (SELECT a.barcode,b.company_name,a.company_no,a.in_date,d.employee_name,a.addresser_name,a.send_address,a.addresser_phone,c.out_date FROM post_info a
 Left join express_company_info b on a.company_no = b.express_company_no
 left join post_out_info c on c.barcode=a.barcode
 left join employee_info d on d.employee_job_no=c.employee_no 
 WHERE  a.post_state in ('10','11','12') and a.postal_no = 'BJBSD00001'  ) as tb group by barcode)
) a order by out_date

转载于:https://www.cnblogs.com/Deckard/archive/2011/07/27/2118560.html