--删除冗余数据 [Title] 重复
select * from [Sys_MonitorInfo] where isGrab =1 and ID in (
select ID from (
SELECT ID,--加ID为了识别重复那条的ID (ID唯一)
ROW_NUMBER()OVER(PARTITION BY
[Title] --验证重复字段
ORDER BY RAND()) AS RN FROM [Sys_MonitorInfo] where isGrab =1
) AS t WHERE RN>1) -->1 证明重复 =1 代表只有一条
说明:表名:[Sys_MonitorInfo]
ID:唯一标识
[Title]:标题 Title 有重复的情况 如果有多个按逗号拼接即可
where 条件可加可不加 具体情况具体分析