How would I write a SQL statement to show all duplicate records only, on a field, with no unique records?

rec no field1 results => recno field1
1 a 1 a
2 b 3 a
3 a 4 a
4 a 6 d
5 c 7 d
6 d
7 d


TIA
Jim