菜鸟学院
sybase数据库分页
时间 2020-05-09
标签
sybase
数据库
分页
select * from (select RANK() OVER (ORDER BY a.kpi_id) SID, a.* from tsqm_kpi a where seq =0 and state = '0' ) obj where sid <=10 and sid > 5