摘要: uid为重复关键字select * from TableName where [uid] in (select [uid] from TableName group by [uid] having count([uid])>1) and id not in (select min(id) from TableName group by [uid] having count([uid])>1)delete from TableName where [uid] in (select [uid] from TableName group by [uid] having count([ui 阅读全文
posted @ 2011-04-16 00:42 冷寒生 阅读(153) 评论(0) 推荐(0) 编辑
IT知识库