SQLServer查询今天某列重复记录，急急急！

[soamu]

如题。。。谢谢。

[吉普赛的歌]

请贴出你的表结构和示例数据

[二月十六]

--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([addtime] Date,[col] int)
Insert #T
select '2022-07-25',1 union all
select '2022-07-25',1 union all
select '2022-07-26',1 union all
select '2022-07-26',1 union all
select '2022-07-26',2
Go
--测试数据结束
SELECT col FROM (
SELECT *,
ROW_NUMBER() OVER (PARTITION BY addtime, col ORDER BY GETDATE()) rn
FROM #T
WHERE DATEDIFF(DAY, GETDATE(), addtime) = 0)t
WHERE rn>1

[二月十六]

[幸福感奇差]

select addtime, col
from t
where addtime = current_date
group by addtime, col
having count(*) > 1