时间排序，去重复SQL语句

最新推荐文章于 2023-04-13 13:37:32 发布

转载最新推荐文章于 2023-04-13 13:37:32 发布 · 417 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Deckard/archive/2011/07/27/2118560.html

文章标签：

#c#

本文深入解析了一段复杂的SQL查询语句，该语句通过多个LEFT JOIN操作从不同的表中选择特定的数据，包括条形码、出库日期、公司名称等信息，并通过GROUP BY和MAX函数确保获取每个条形码最新的出库日期。

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