a表:ke_school_student
b表:ke_school_student_contact
b表:ke_school_student_contact
解决方案 »
- ORACLE 链接SQLSERVER
- 为什么dblink 可以查虚表,却查不了别的表
- SQL 如何改变直接查询出来的结果
- win2003 DataCenter Edition+oracle 9i中 错误1053:服务没有及时响应启动或控制请求
- 归档日志路径的一个问题~
- 9i装完后要求修改SYS和SYSTEM的密码,又不想修改应该怎么做
- 求救!我的OracleOraHome92ManagementServer启动不了
- 哪里有oracle8.17 版本的下载!
- 请问那有关于oracle9i的电子般的中文图书可下载
- 〔que〕oracle中number类型的有效精度??
- oracle锁
- ORACLE试图中访问其他表空间的表
(select cardno from ke_school_student where company_id = a.company_id and student_name = a.student_name and a.contact_kind = '01' and rownum<2)
where exists (
select cardno from ke_school_student where company_id = a.company_id and student_name = a.student_name and a.contact_kind = '01'
)
(select distinct cardno from ke_school_student where company_id = a.company_id and student_name = a.student_name and a.contact_kind = '01' having count(*) = 1);
update ke_school_student_contact a set a.cardno = (select b.cardno from ke_school_student b where b.student_name = a.student_name and a.company_id = b.company_id )
where b.student_name = a.student_name and a.company_id = b.company_id
再想办法处理剔除的信息.