Advanced Duplicate Row Query in SQL

gistfile1.sql

  SELECT COUNT(*) as duplicate_count,
         application_id,
         lock_version,
         asset_id,
         customer_id,
         received_date,
         fee_amount,
         created_at,
         updated_at
    FROM application_versions
GROUP BY application_id,
         lock_version,
         asset_id,
         customer_id,
         received_date,
         fee_amount,
         created_at,
         updated_at
  HAVING COUNT(*) > 1