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