DB2

DB2分页查询：

SELECT * FROM (Select 字段1,字段2,字段3,rownumber() over(ORDER BY 排序用的列名 ASC) AS rn from 表名) AS a1 WHERE a1.rn BETWEEN 10 AND 20

表示提取第10到20的纪录

DB2创建表：

create table pet
(
  ID INTEGER not null generated by default as identity,
  NAME VARCHAR(10) not null,
  SEX CHAR(8) not null,
  BIRTHDAY VARCHAR(80) not null,
  OWNER  VARCHAR(1) not null,
  primary key (ID)
);

DB2插入数据：

insert into pet (ID,NAME,SEX,BIRTHDAY,OWNER) values ('001','Poly','F','20110906','Jacky'),('002','Sandy','M', '20110906','Susan');