Oracle组使用最小日期 [英] Oracle group using min date

问题描述

我有一个这样的声明:

 select REFNUMBER,
        SomeDate,
        Somecolumn1,
        Somecolumn2
 from Table

如何选择与REFNUMBER分组的最低日期关联的行?

How can I select the row associated with the lowest date grouped by REFNUMBER ?

推荐答案

使用ROW_NUMBER()分析功能:

SELECT *
FROM   (
  SELECT REFNUMBER,
         SomeDate,
         Somecolumn1,
         Somecolumn2,
         ROW_NUMBER() OVER ( PARTITION BY REFNUMBER ORDER BY SomeDate ) As rn
  FROM   Table
)
WHERE  rn = 1

这篇关于Oracle组使用最小日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！