请问如何找出表中有重复记录的编号,(只要找出有重复编号就行,不要找出所有重复的编号!) select bm from sell group by bm having count(bm)>1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select bm,count(bm) group by bmwhere count(bm)>1 select bm,count(bm) from bm group by bm having count(bm)>1绝对可用,已经测试过 在查询字段前加 DISTINCT select DISTINCT bm from sell where (bm in (select bm from sell group by bm having count(*)>1 )) select distinct bm from sell where bm in (select bm from sell group by bm having count(*)>1) select bm from sell group by bm having count(*)>1 select bm from sell group by bm having count(bm)>1 SELECT DISTINCT bmFROM sell SELECT DISTINCT bm FROM sell where bm in (select bm from sell group by bm having count(*)>1) 简单的一句就行了.select bm from sell group by bm having count(bm)>1 数据读入数据库 怎么取得动态的某一列的列号 请问 哪里有SQL Server 2000的个人版下载啊?谢谢!!! 周日期转变的疑惑? 问条sql语句 错误"字符串数据,右截位"是什么意思? 数据库用户表如果空间不足,会导致什么现象。? 关于数据的恢复 如何给系统表加触发器? 请给高手讲讲全文索引的问题! 立即给分,关于asp调用sqlserver存储过程返回值问题。 記錄篩選問題
where count(bm)>1
绝对可用,已经测试过
FROM sell
select bm from sell group by bm having count(bm)>1