Looking for help reporting duplicates and null marks
Of course.

SELECT * FROM (
SELECT  id, 
        mainfield, 
        location,
        COUNT (id) OVER (PARTITION BY mainfield) counter
FROM    maintable a
) where counter &gt; 1 or mainfield IS NULL
ORDER BY mainfield;