3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
...全文
请发表友善的回复…
发表回复
qqba 2003-12-24
select * from table1 a where a.id!=(select max(id) from table b where a.coll=b.coll)
qiaolin53 2003-12-24
select column,coount(*) from table1
group by column
having count(*)>1
group by column
having count(*)>1
newline 2003-12-24
谢谢！
victorycyz 2003-12-24
select a.*
from table1 a join
( select col1
from table1
group by col1
having count(*)>1
) b
on a.col1=b.col1
from table1 a join
( select col1
from table1
group by col1
having count(*)>1
) b
on a.col1=b.col1