پیدا کردن موارد تکراری در دیتابیس SQL Server

SELECT rr.MessageId,
       rr.GapId,
       rr.MessageType,
       COUNT(*) AS CountData
FROM dbo.RawMessage rr
GROUP BY rr.MessageId, rr.GapId, rr.MessageType
HAVING COUNT(*) > 1

SELECT r.Id,
       r.MessageId,
       r.GapId,
       r.EngineId,
       r.MessageType,
       CAST(r.DbEntryDateTime AS TIME) AS DbEntryTime
FROM (SELECT rr.MessageId,
             rr.GapId,
             rr.MessageType,
             COUNT(*) AS CountData
      FROM dbo.RawMessage rr
      GROUP BY rr.MessageId, rr.GapId, rr.MessageType
      HAVING COUNT(*) > 1) ii
         INNER JOIN dbo.RawMessage r
                    ON r.MessageId = ii.MessageId AND r.MessageType = ii.MessageType AND r.GapId = ii.GapId