求一SQL语句 SQL中有如下数据11221133 11是两条重复数据 22 33不重复如何将重复的数据删掉 只剩下单独的数据 把11给删除后数据库成2233 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 假设为IDdelete from tb where id in (select id from tb group by id having count(*) > 1) delete from tb where tb.columnname in(select columnname from tb group bycolumnamehaving count(*)>1 ) 设表为ID11121113DELETE FROM Table_1 WHERE ID IN(SELECT ID FROM Table_1 GROUP BY ID HAVING(COUNT(*))>1) delete from table where id in (select id from table group by id having count(*)>1) 你要用的是2008的话,可以直接用MERGE DELETE TESTWHERE ID IN ( SELECT ID FROM TEST GROUP BY ID HAVING COUNT(ID) > 1 )ID就是重复的列 DELETE TESTWHERE ID IN ( SELECT ID FROM TEST GROUP BY ID HAVING COUNT(ID) > 1 ) delect delete from tab where id in (select id from tab group by id having (count(*)>1)) 求教关于多表关联查询的问题 求解数据库修复 在于关系运算中的自然连接 时间 怎么解决:”sum or average aggregate 运算不能以 nvarchar 数据类型作为参数。“ sql语句关于全局变量的问题 批量修改(100分求解) 如何在sql语句中实现递归查询? VFP5的类的编程问题 有没有什么办法获取其他spid上的临时表数据 求将命令整合起来 数据库的用户名
delete
from tb
where
tb.columnname
in(
select columnname from tb
group by
columname
having count(*)>1 )
ID
11
12
11
13
DELETE FROM Table_1 WHERE ID IN
(SELECT ID FROM Table_1 GROUP BY ID HAVING(COUNT(*))>1)
WHERE ID IN (
SELECT ID
FROM TEST
GROUP BY ID
HAVING COUNT(ID) > 1
)ID就是重复的列
WHERE ID IN (
SELECT ID
FROM TEST
GROUP BY ID
HAVING COUNT(ID) > 1
)