Delete from emp e
where e.rowid >
(select min(f.rowid) from emp f
where f.empno=e.empno); 我做了一个,但执行速度很慢,
select * from ls_teacher_crash
where jsxx_jsh || sjdy_dm in
(select jsxx_jsh || sjdy_dm from ls_teacher_crash e
where e.rowid >
(select min(f.rowid) from ls_teacher_crash f
where f.jsxx_jsh = e.jsxx_jsh and f.sjdy_dm = e.sjdy_dm and zcCrash(e.sksj_zc,f.sksj_zc) = 1)
)
order by jsxx_jsh,sjdy_dm;
其中zcCrash是一个自己写的判断两个字符串是否相等的函数。
where e.rowid >
(select min(f.rowid) from emp f
where f.empno=e.empno); 我做了一个,但执行速度很慢,
select * from ls_teacher_crash
where jsxx_jsh || sjdy_dm in
(select jsxx_jsh || sjdy_dm from ls_teacher_crash e
where e.rowid >
(select min(f.rowid) from ls_teacher_crash f
where f.jsxx_jsh = e.jsxx_jsh and f.sjdy_dm = e.sjdy_dm and zcCrash(e.sksj_zc,f.sksj_zc) = 1)
)
order by jsxx_jsh,sjdy_dm;
其中zcCrash是一个自己写的判断两个字符串是否相等的函数。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货