Siebel SQLs/Error Messages >  Find Duplicate Addresses in s_con_addr table

This SQL shows duplicate addresses in s_con_addr table
Checked against Siebel 8.1 and Oracle 11g

SELECT created,row_id, accnt_id, addr_per_id,
relation_type_cd, start_dt, bu_id, db_last_upd_src
 FROM S_CON_ADDR WHERE ACCNT_ID in (
SELECT ACCNT_ID
  FROM S_CON_ADDR
  GROUP BY ADDR_PER_ID, ACCNT_ID
  having count(ADDR_PER_ID)>1 and
  count(ACCNT_ID)>1)
  order by accnt_id;