×

Loading...

My answer are select * from T T1 where exists(select A from T where A=T1.A group by A having count(1)>1); or select * from T T1 where exists(select A from T group by A having count(1)>1 and A=T1.A);

cyt (会飞的鹿)
But what's the difference?
(#261114@0)
2001-11-14 -04:00
This post has been archived. It cannot be replied.
Page address has been copied. To share, click to copy page address.
Share Online by QR Code

Back To Topic: 闲来无事, 出道ORACLE SQL的题考考大家. 这是在下几个月前工作中遇到的问题, 看似简单, 其实不然.

Back To Forum: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论