按照日期降序排序,取前五条数据

来源:互联网 发布:华为上机考试题库java 编辑:程序博客网 时间:2024/06/18 10:53
select *
            from (select t1.hr_no,
                         t1.hr_date,
                         (row_number() over(order by t1.hr_date desc)) mm
                    from T_HR t1) t2
           where mm <= 5
0 0
原创粉丝点击