17,377
社区成员
发帖
与我相关
我的任务
分享
begin
for c in select Rowid from employee
where rownum < 3
order by board_date desc
loop
update employee set level_info='Senior Employee' where rowid = c.rowid;
end;
commit;
end;
(ORDER BY 工作经验 DESC)-> (ROWNUM <= 2)
[Quote=引用楼主 xiaotianwang0702 的帖子:]