3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
...全文
请发表友善的回复…
发表回复
yitangliang 2006-01-24
select * from A where bb in (select bb from A group by bb having count(*)>1)
lsqkeke 2006-01-23
select tb.* from tb ,(select bb,a=count(bb) from tb group by bb)b
where tb.bb=b.bb and b.a>1
where tb.bb=b.bb and b.a>1
lsqkeke 2006-01-23
select * from tb ,(select bb,a=count(bb) from tb group by bb)b
where tb.bb=b.bb and b.a>1
where tb.bb=b.bb and b.a>1
lw1a2 2006-01-23
select *
from A t
where (select count(1) from A where bb=t.bb)>1
lsqkeke 2006-01-23
我写错了 ：（
lsqkeke 2006-01-23
select * from tablename where count(bb)>1