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

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

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