Oracle分析函数的项目实践实例 

1 SELECT *
2   FROM SSE2_FLOW_EXPENSE T1
3   JOIN (SELECT SFEL.*,
4                ROW_NUMBER() OVER(PARATITION BY SFEL.FE_EXPENSENO ORDER BY SFEL.LOG_HAPPENDATE DESC) RN
5           FROM SSE2_FLOW_EXPENSE_LOG SFEL) T2
6     ON T1.FE_EXPENSENO = T2.FE_EXPENSENO
7    AND T2.RN = 1

 

posted @ 2016-05-15 11:27  chenxiangxiang  阅读(265)  评论(0)  编辑  收藏  举报