首页 > 代码库 > sql 分页row_number() over(order by key)

sql 分页row_number() over(order by key)

?
1
2
3
4
select * from (
                select  row_number() over(order by BD008_001) as row ,* from
                                                                            (select * from bd008)t
              ) tt where tt.row between 1 and 30