邹建大哥请进来帮忙！！在线等急！！！

Question

http://expert.csdn.net/Expert/topic/2636/2636859.xml?temp=2.915591E-02

Answer 1

select productno,resid,dosagedetail from demanddetail
group by productno,resid,dosagedetail
having cound(*)>1

Answer 2

select * 
from demanddetail 
group by productno,resid,dosagedetail 
having count(*)>1

Answer 3

select * from demanddetail a
where exists(select productno,resid,dosagedetail from demanddetail b
  where a.productno=b.productno and a.resid=b.resid and a.dosagedetail=b.dosagedetail
  group by productno,resid,dosagedetail having count(*)>1)

Answer 4

select a.*
from demanddetail a join(
select productno,resid,dosagedetail
from demanddetail
group by productno,resid,dosagedetail
having count(*)>1
)b on a.productno=b.productno and a.resid=b.resid and a.dosagedetail=b.dosagedetail

Answer 5

搞得复杂了，简单点：
select * from demanddetail a
where (select count(*) from demanddetail b
  where a.productno=b.productno and a.resid=b.resid and a.dosagedetail=b.dosagedetail)>1