Sorry about late. I was answering a phone call.

contact (Contact)
This one seems working:

select T2.A, T1.B from T T1, T T2
where T1.A = T2.A group by T2.A, T1.B having count(T2.A)>1
(#260300@0)
2001-11-13 -05:00

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

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=260300