sql句除相同的
表中存在多一模一的，怎除些多余，它只剩下一。!!!



[解决办法]
delete from 表　where id in
(
select id from 表 as T
where id > (select min(id) from 表 where 字段=T.字段)
)
字段：有重复记录的字段
[解决办法]
select distinct * into 临时表 from 表1
delete from 表1 group by 所有字段 having count(*) > 1
insert into 表1 select * from 临时表
drop table 临海表