Informix 中分页查询语句

 

1. SELECT SKIP 10 FIRST 10 * FROM a1330_1 WHERE dbank_id = '651080000' order by row_num;   

SELECT SKIP 10 FIRST 10 * FROM a1330_1 WHERE dbank_id = '651080000' order by row_num; 

SKIP n ：跳过N FIRST n ：获取前n条记录 SKIP 10 FIRST 10 :跳过前10条获取接下来的10条

Informix子查询

SELECT first 10 * FROM TABLE(MULTISET (SELECT FIRST 20 * FROM a1330_1 where dbank_id = '651080000' order by row_num )) a order by row_num desc TABLE(MULTISET(……)) a : 创建视图，别名为a