求一条查询语句: select col3 from t group by col3 having count(*) > 1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from your_tablewhere col3 in ( select col3 from (select col3,count(*) aa from your_table) where aa >1 ) select col1,col2,count(col3) from table1 group by col1,col2 having count(col3)>1 有點錯誤,更正一下select * from your_tablewhere col3 in ( select col3 from (select col3,count(*) aa from your_table group by col3) where aa >1 ) ORA-29532 ora_06512 请各位帮忙解决一下,谢谢~ 附图 求助简单SQL 筛选 ORA-00600: 内部错误代码,参数: [kghGetHpSz1], [0x7E828050], [], [], [], [], [], [] 关于表分区中maxvalues的大小? 上传文件和下载文件......(高手快来) Oracle 中有没有限制某些IP(比如:192.168打头的)登入数据库的功能 , 如何设置 ? 关于oracle9i的配置问题 oci问题 这种情况如何恢复? 触发器表在哪。 Oracle数据库周期性地报一个奇怪的异常 求助数据库连接问题(jsp)
where col3 in
(
select col3
from (select col3,count(*) aa from your_table)
where aa >1
)
select * from your_table
where col3 in
(
select col3
from (select col3,count(*) aa from your_table group by col3)
where aa >1
)