我的ZSGL表中SSMC字段不可能重复,要用UNION ALL 吗?
解决方案 »
- 写了个最简单的触发器,居然也报错。。。。。。(附SQL语句)
- oracle 的大数据多表查询怎么优化
- 高分求sql语句!
- 在应用程序中要连接oracle数据库,是否必须安装oracle客户端?
- group by 和order by
- 安装的时候Database Configuration Assistant失败!!!
- 我在oms中导出数据库数据,遇到错误如下:已经添加了节点首选项证明,以及将备份用户设置为作为批处理用户登陆阿
- 请问ORACLE中取整是哪个函数,不要四舍五入,多谢
- select top 问题
- HQL 多个关键字查询一个字段
- 如何取得新插入行的某个值
- 请问SQLplus里面字符串为空用什么表示?谢谢!
select trim(ssmc) from zsgl
minus
select trim(ssmc)
from
(
select cblcode ssmc from c_cable
union
select dpnum ssmc from c_dpoint
union
select mhnum ssmc from d_manhle
union
select cabnum ssmc from c_cabint
union
select dtype||dnum ssmc from d_ductgp
union
select cblcode ssmc from w_fbecbl
union
select cabnum ssmc from w_fabint
union
select ternum ssmc from w_terminator
union
select plinename ssmc from d_pline
union
select dpnum ssmc from w_dpoint
) A
SELECT SSMC FROM zsgl WHERE SSMC NOT IN
(select cblcode ssmc from c_cable) AND
SSMC NOT IN
(select dpnum ssmc from c_dpoint) AND
SSMC NOT IN
(select mhnum ssmc from d_manhle)...接着下去then ok
select ssmc from zsgl,(select cblcode ssmc from c_cable
union
select dpnum ssmc from c_dpoint
union
select mhnum ssmc from d_manhle
union
select cabnum ssmc from c_cabint
union
select dtype||dnum ssmc from d_ductgp
union
select cblcode ssmc from w_fbecbl
union
select cabnum ssmc from w_fabint
union
select ternum ssmc from w_terminator
union
select plinename ssmc from d_pline
union
select dpnum ssmc from w_dpoint) temptb
where zsgl.ssmc=tempdb.ssmc(+) and tempdb.ssmc is null试试效率 ?