SQL query to list records with duplicate fields

list_records_with_duplicate_fields.sql

# table: _TABLE_
# possibly duplicated field: _FIELD_

select id, _FIELD_, duplicate_count from (
  select id, _FIELD_, 
  count(_FIELD_) over (partition by _FIELD_) as duplicate_count
  from _TABLE_ where _FIELD_ is not null
) as processed_table
where duplicate_count > 1 
order by duplicate_count DESC, _FIELD_;