求分组第一行数据

SELECT Finterid,
Fbillno,
Fdate,
rownum
FROM
(select Finterid,Fbillno,Fdate, row_number() over(partition by Fbillno order by Fdate desc)
as rowNum from icstockbill) k
where k.rowNum=1

posted @   辣椒粉  阅读(167)  评论(0编辑  收藏  举报
点击右上角即可分享
微信分享提示