说清楚一些,
select X from (select X,count(*) num from A group by colname)
where num>1;
select X from (select X,count(*) num from A group by colname)
where num>1;
解决方案 »
- HP unix系统装了oracle10G,报错版本的8.1.7
- 本人刚学oracle 不明白为什么同时需要存储过程和函数啊?感觉存储过程完全可以替代函数啊? 勿喷啊,高手给点意见看看
- oralce redo
- conn.open()时发生例外:ORA-00162: external dbid length 17 is greater than maximum (16) 什么原因?
- 在oracle中,怎样对表进行加锁?
- 简单问题,请问怎么解决?谢谢!
- 奇怪的問題,cpu竟然到達100%
- 如何在建表时候指定其数据的变化不引用回滚段.
- 【求助大神】Oracle表字段更新问题
- 数据量少时的select into和游标
- 请问各位一般用什么做表的关键字
- 快照建立却不能刷新
group by keyField
having count(x)>1;
group by x
having count(*)>1
2 exists (select 1 from zhyw.tj_2002 b where a.msis = b.msis
3* and group by b.msis having count(*) >1)