I'm guessing this is what you are looking for:


WITH
Duplicates
AS
(
    SELECT    [Policy]
    FROM    Insurance
    GROUP BY [Policy]
    HAVING COUNT(ID) > 1
)

SELECT    I.ID, I.[Policy]
FROM    Insurance I
INNER JOIN
        Duplicates D
    ON    D.[Policy] = I.[Policy]