select t.物品 from (select * from a,b where b.柜子=a.柜子(+) t
group by 仓库,物品 having count(1)>1;
group by 仓库,物品 having count(1)>1;
解决方案 »
- oracle10g安装clusterware后的节点问题
- Oracle 11g RAC系列一【分享】
- Oracle问题请教
- 监听程序: 所有适用例程都处于受限模式,这是什么意思?如何解决这个问题?
- 统计问题求解
- PLSQL developer6.0.5里编辑BLOB字段时出现"无效的窗口句柄"
- 请问如何改变已有记录的表的字段名称呢?
- oracle9i的安装错误?????????
- 如何用sql语句在oracle中得到任意年份的年,季度,月份,日期列表
- 求助,大神帮帮忙,oracle无法启动
- 如何在oracle中建立自动加一字段?
- 使用PL/SQL TOAD,OBJECT Browser调试存储过程时,如何把cursor类型的输入参数赋值。
group by 仓库,物品 having count(1)>1;
from a,b
where a.cid = b.cid
group by a.sid,a.cid,b.item
having max(a.sid||a.cid) <> min(a.sid||a.cid);
from a,b
where a.cid = b.cid
group by a.sid,b.item
having count(1) > 1
bzszp(SongZip)的语句好像可以,
但我想列出一个比较详细的错误清单:仓库 柜子 物品
--------------------
AA 01 555
AA 02 555
BB 11 666
BB 12 666
........谢谢指教
select c.sid,b.cid,c.item from (
(select a.sid,b.item
from a,b
where a.cid = b.cid
group by a.sid,b.item
having count(1) > 1 )c,a,b
where a.cid = b.cid
and c.cid = b.cid
and c.item = b.item
select c.sid,b.cid,c.item from (
(select a.sid,b.item
from a,b
where a.cid = b.cid
group by a.sid,b.item
having count(1) > 1 )c,a,b
where a.cid = b.cid
and c.cid = b.cid
and c.item = b.item通不过啊,大哥
select c.仓库,c.柜子,c.物品
from
(select a.仓库,a.柜子,b.物品
from a,b
where a.柜子(+) = b.柜子) c,
(select a.仓库,a.柜子,b.物品
from a,b
where a.柜子(+) = b.柜子) d
where c.仓库 = d.仓库 and c.柜子 <> d.柜子;
多了个'('
select c.sid,b.cid,c.item from
(select a.sid,b.item
from a,b
where a.cid = b.cid
group by a.sid,b.item
having count(1) > 1 )c,a,b
where a.cid = b.cid
and c.cid = b.cid
and c.item = b.item