SELECT row.* FROM (
  SELECT ARRAY_AGG(t LIMIT 1)[OFFSET(0)] row
  FROM `{{project}}.{{dataset}}.{{table}}` t
  GROUP BY id
  HAVING COUNT(*) > 1
)