sql server 取记录时部分字段相同去除重复

最新推荐文章于 2019-05-07 17:28:59 发布

o0wufan0o

最新推荐文章于 2019-05-07 17:28:59 发布

阅读量957

点赞数

分类专栏： sql server 文章标签： sql server c

本文链接：https://blog.csdn.net/o0wufan0o/article/details/7691692

版权

sql server 专栏收录该内容

42 篇文章 0 订阅

订阅专栏

select b.StoreID,b.StoreName,b.SaleAreaName,b.ContactName,b.Tel,b.StoreTypeName,b.OrderCount,
       b.Price,b.ProductName,b.BrandID,b.BrandName,
       b.ProductID, b.UserName,b.CheckTime
     from (select a.StoreID,
         a.StoreName,
         a.SaleAreaName,
         a.ContactName,
         a.Tel,
         a.StoreTypeName,
         a.OrderCount,
         a.Price,a.ProductName,a.BrandID,a.BrandName,
         a.ProductID,
         a.CheckTime,
         a.UserName,
--         count(1) over(partition by a.StoreID) as count_id,
--         count(1) over(partition by a.StoreID, a.ProductID) as count_price,
         row_number() over(partition by a.StoreID, a.ProductID order by a.CheckTime desc) as row_c
       from VTBasProductBrand a) b
   where b.row_c = 1