sqlserver groupby分组后取第一个sql

最新推荐文章于 2023-06-07 11:27:31 发布

「已注销」

最新推荐文章于 2023-06-07 11:27:31 发布

阅读量940

点赞数

分类专栏： mysql 文章标签： sql sqlserver 数据库

本文链接：https://blog.csdn.net/ashylya/article/details/127843589

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

SELECT
   ROW_NUMBER ( ) OVER ( ORDER BY a.FillingDateTime DESC ) AS RowNum,
   a.*
FROM
   (
   SELECT
       ROW_NUMBER ( ) OVER ( partition BY w.GasCylinderGuid ORDER BY w.FillingDateTime DESC ) rn,
       w.*,
       f.FillingStationName,
       r.RegionInfoName
   FROM
       data.GasCylinderWorkFlow w WITH ( nolock )
       LEFT JOIN base.FillingStation f WITH ( nolock ) ON w.FillingStationGuid = f.FillingStationGuid
       LEFT JOIN auth.RegionInfo r WITH ( nolock ) ON r.RegionInfoCode = LEFT ( f.DivisionCode, 6 )
   WHERE
       w.Status = 0
       AND f.DivisionCode LIKE '320509%'
       AND w.FillingDateTime >= '2022-11-12'
       AND '2022-11-13' > w.FillingDateTime
   ) a
WHERE
   a.rn=1