34,837
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
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
