查询数据库指定字段重复项的一条数据

以下为引用的内容：
CREATE TABLE [cc] (
[a] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[b] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[c] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

--数据：
"1","a","c"
"2","c"
"3","b","c"
"4","c","d"
"5","d"


CREATE TABLE [temp] (
[id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO


--实现
declare @cname nvarchar(20)
declare @mname nvarchar(20)
Declare Cur Cursor For select distinct b,c from cc
Open Cur
Fetch next From Cur Into @cname,@mname
While @@fetch_status=0
Begin
insert into temp
select top 1 a from cc where b=@cname and c=@mname
Fetch next From Cur Into @cname,@mname
End
Close Cur
Deallocate Cur


select * from cc

select * from cc where a in (select id from temp)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

编程之家 52php.cn 如何SQL SERVER 查询数据库指定字段重复项的一条数据，今天小编在博客园看到该问题的实例命令代码，现在特别转载了分享给各位访客，希望对您有所帮助。