sql查询部分字段重复的记录

这个能显示出你要求的数据，还显示了出现次数，当然，不需要的话，您可以将出现次数取掉。
select count(1) as 出现次数,setname,setnum from table_name
where datediff(DAY,subtime,getdate())<=30
group by setname,setnum having count(1)>1

======
添加这个条件子句，表示只选当前时间及之前的30天内的记录。
where datediff(DAY,subtime,getdate())<=30

加上日期限制
access==================
select distinct setname , setnum from table_name
where subtime between date() and dateadd('m',-1,date())

sql server ====================

select distinct setname , setnum from table_name
where subtime between getdate() and dateadd('m',-1,getdate())

select table_name.setname,table_name.setnum from table_name a,(select distinct setname,setnum from table_name) b where b.setname=table_name.setname and b.setnum=table_name.setnum

select * from 表
注意不要加 ”（distinc）“是免重复