查询重复记录问题,请教 select xm,xfzfrom table group by xm,xfzhaving count(1) > 1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a.* from tb where exists(select xm,sfz from tb group by xm,sfz having count(*) > 1) select xm,sfz from Table1 group by xm,sfz having count(xm)>1 --我上面那个错了.create table tb(id int , xm varchar(10) , sfz varchar(10))insert into tb values(1 , '1' , '1')insert into tb values(2 , '1' , '1')insert into tb values(3 , '2' , '1')goselect a.* from tb a where cast(xm as varchar) + ',' + cast(sfz as varchar) in (select cast(xm as varchar) + ',' + cast(sfz as varchar) from tb group by cast(xm as varchar) + ',' + cast(sfz as varchar) having count(*) > 1)drop table tb/*id xm sfz ----------- ---------- ---------- 1 1 12 1 1(所影响的行数为 2 行)*/ 如何调用自定义函数以及其他问题 关于使用数据集进行模糊查询 请问按记录和字段内容循环的问题 MSSQL2005 消息8614,级别16,insert exec不能嵌套 求一个简单问题的答案,没分了! SQL server 2005安装问题 SQL SERVER 2008 在执行T-SQL时提示:当前命令发生了严重错误。应放弃任何可能产生的结果 sql 2005 配置数据库邮件出错 类似矩阵转换的sql语句,有难度,请大家一定指教,因为....急!!!!!! 怎样处理可以让客户端免去连接和验证服务器的操作? 新开帖求解列合并的一个写法 isnull 的问题
create table tb(id int , xm varchar(10) , sfz varchar(10))
insert into tb values(1 , '1' , '1')
insert into tb values(2 , '1' , '1')
insert into tb values(3 , '2' , '1')
goselect a.* from tb a where cast(xm as varchar) + ',' + cast(sfz as varchar) in (select cast(xm as varchar) + ',' + cast(sfz as varchar) from tb group by cast(xm as varchar) + ',' + cast(sfz as varchar) having count(*) > 1)drop table tb/*id xm sfz
----------- ---------- ----------
1 1 1
2 1 1(所影响的行数为 2 行)
*/