SqlServer 1 对 N 关系重复留空示例

最新推荐文章于 2022-05-16 11:38:30 发布

安得权

最新推荐文章于 2022-05-16 11:38:30 发布

阅读量282

点赞数

分类专栏： [ 03 ] SQL Server

本文链接：https://blog.csdn.net/CsethCRM/article/details/102680158

版权

[ 03 ] SQL Server 专栏收录该内容

113 篇文章 0 订阅

订阅专栏

select 
 ( case when SortNo = 1 then Hawb else '' end) Hawb
,( case when SortNo = 1 then Convert(varchar(50), LogisticStatus) else '' end) LogisticStatus
, ProductCode,GoodsNameEn,SortNo
 from 
(
    select t1.Hawb,t1.LogisticStatus,t2.ProductCode,t2.GoodsNameEn,
    ROW_NUMBER()OVER(PARTITION BY t1.Hawb  ORDER BY t2.ProductCode) SortNo
     from 
    ( SELECT Hawb,LogisticStatus FROM HawbHead  WHERE Hawb IN  ('WSEJA00943541','WSEJA00936751','WSEJA00942885','WSEJA00938700','WSEJA00876934','WSEJA00946842','WSEJA00946411','WSEJA00945534','WSEJA00945416','WSEJA00945302','WSEJA00945000','WSEJA00932875') )
    t1 
    join 
    (SELECT Hawb,ProductCode,GoodsNameEn FROM HawbBody WHERE Hawb IN  ('WSEJA00943541','WSEJA00936751','WSEJA00942885','WSEJA00938700','WSEJA00876934','WSEJA00946842','WSEJA00946411','WSEJA00945534','WSEJA00945416','WSEJA00945302','WSEJA00945000','WSEJA00932875'))
    t2 on t1.Hawb = t2.Hawb
) Result