ta表:
create table ta(id int,name varchar(10));
insert into ta values(1,'a');
insert into ta values(1,'a');
insert into ta values(2,'b');
insert into ta values(3,'c'); id和name两个字段
id ¦ name
1 ¦ a
2 ¦ b
1 ¦ a
3 ¦ c select id from ta where 1=1 group by id 结果是3条:
id
1
2
3 分页sql:
第1页:
SELECT id FROM (SELECT A.id,ROWNUM RN FROM (SELECT id FROM ta) A WHERE ROWNUM <=1) WHERE RN > =1 group by id; 结果是:
id
1
第2页:
SELECT id FROM (SELECT A.id,ROWNUM RN FROM (SELECT id FROM ta) A WHERE ROWNUM <=2) WHERE RN > =2 group by id; 结果是:
id
1 第3页:
SELECT id FROM (SELECT A.id,ROWNUM RN FROM (SELECT id FROM ta) A WHERE ROWNUM <=3) WHERE RN > =3 group by id; 结果是:
id
2 第4页:
SELECT id FROM (SELECT A.id,ROWNUM RN FROM (SELECT id FROM ta) A WHERE ROWNUM <=4) WHERE RN > =4 group by id; 结果是:
id
3
create table ta(id int,name varchar(10));
insert into ta values(1,'a');
insert into ta values(1,'a');
insert into ta values(2,'b');
insert into ta values(3,'c'); id和name两个字段
id ¦ name
1 ¦ a
2 ¦ b
1 ¦ a
3 ¦ c select id from ta where 1=1 group by id 结果是3条:
id
1
2
3 分页sql:
第1页:
SELECT id FROM (SELECT A.id,ROWNUM RN FROM (SELECT id FROM ta) A WHERE ROWNUM <=1) WHERE RN > =1 group by id; 结果是:
id
1
第2页:
SELECT id FROM (SELECT A.id,ROWNUM RN FROM (SELECT id FROM ta) A WHERE ROWNUM <=2) WHERE RN > =2 group by id; 结果是:
id
1 第3页:
SELECT id FROM (SELECT A.id,ROWNUM RN FROM (SELECT id FROM ta) A WHERE ROWNUM <=3) WHERE RN > =3 group by id; 结果是:
id
2 第4页:
SELECT id FROM (SELECT A.id,ROWNUM RN FROM (SELECT id FROM ta) A WHERE ROWNUM <=4) WHERE RN > =4 group by id; 结果是:
id
3
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货