SQL to find Duplicates

SELECT FIELD1, COUNT(*) AS A FROM TABLE_NAME
WHERE RECORD_YEAR = 2007
GROUP BY FIELD1 HAVING (COUNT(FIELD1) > 1)

or to find only one occurence of a value in the field:

SELECT FIELD1, COUNT(*) AS A FROM TABLE_NAME
WHERE RECORD_YEAR = 2007
GROUP BY FIELD1 HAVING (COUNT(FIELD1) = 1)