17,086
社区成员
发帖
与我相关
我的任务
分享
select * from 表a where sex='男' and rownum<=10慢多了
--这个肯定是有问题了 你的直接是给每个记录加个序号
update 表a set note='aaa' where id in(select id from (select id from 表a where sex='男' order by age) where rownum<=10)
--这个是可以的
--也可以用下面的
update 表a set note='aaa' where id in
(select id from (select id,row_number() over(order by age,rowid) rn from 表a where sex='男') t where rn<=10)
select count(1) from a;
次
update
(
select * from (select * from 表a where sex='男' order by age) where rownum<=10
)tmp
set tmp.note='aaa' ;
update yuqingdongtai a set isextract='tjf' where exists (select id from (select id ,row_number() over (order by generatetime,id)rn from yuqingdongtai where ishulue=0 and isignore=0 and isextract='0' )b where rn <=20 and a.id=b.id )
UPDATE table1 a SET note='aaa'
WHERE exists (SELECT 1
FROM (SELECT id,age,row_number() over(order by age,id) rk FROM table1
WHERE sex='男') b
WHERE rk<=10 and a.id=b.id);
create table table1 (
id VARCHAR2(2),
sex VARCHAR2(2),
age number
);
alter table table1 add note VARCHAR2(3) default 'bbb'; --增加一列
SELECT * FROM table1 ;
INSERT INTO table1 VALUES('01','男',10);
INSERT INTO table1 VALUES('02','男',14);
INSERT INTO table1 VALUES('03','男',11);
INSERT INTO table1 VALUES('04','男',14);
INSERT INTO table1 VALUES('05','男',10);
INSERT INTO table1 VALUES('06','男',13);
INSERT INTO table1 VALUES('07','女',25);
INSERT INTO table1 VALUES('08','男',23);
INSERT INTO table1 VALUES('09','男',36);
INSERT INTO table1 VALUES('10','男',35);
INSERT INTO table1 VALUES('11','男',24);
INSERT INTO table1 VALUES('12','男',25);
INSERT INTO table1 VALUES('13','男',24);
INSERT INTO table1 VALUES('14','男',15);
INSERT INTO table1 VALUES('15','男',13);