oracle数据库分页语句 rownum函数
select * from (select e.*,rownum rn from (select * from emp) e where rownum <=15) where rn >=5
sqlservier数据库分页语句
SELECT TOP 页大小 *
FROM TestTable
WHERE (ID NOT IN
(SELECT TOP (页大小*(页数-1)) id
FROM 表
ORDER BY id))
ORDER BY ID
mysql数据库分页语句
select * from tableName where 条件
informix数据库分页语句
SELECT SKIP 10 FIRST 10 * FROM table
SKIP n :跳过N FIRST n :获取前n条记录 SKIP 10 FIRST 10 :跳过前10条获取接下来的10条