• What are you doing to get the above pictures. It doesn't look like you have any ordering applied (considering your number go ...336, 337, 338, 1, 2... in your image).

    I would firstly ensure your SELECT statement has an ORDER BY clause:

    SELECT *

    FROM dbo.Governance G

    ORDER BY G.Id_Num;

    Secondly, to get your duplicates:

    SELECT *

    FROM dbo.Governance G

    WHERE G.Id_Num IN (SELECT sq.ID_num

    FROM dbo.Governance sq

    GROUP BY sq.Id_Num

    HAVING COUNT(sq.Id_Num) > 1);

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk