select table_name, active, businessunitid, cost_center, glacct, glsubacct from LAW_DEL_IMGNOW_GLACCT_CHG;

select 
table_name, active, businessunitid, cost_center, glacct, glsubacct, COUNT(*) AS DupCount 
from LAW_DEL_IMGNOW_GLACCT_CHG
GROUP BY 
select table_name, active, businessunitid, cost_center, glacct, glsubacct from LAW_DEL_IMGNOW_GLACCT_CHG
-- HAVING COUNT(*) > 1

quote:

---

Originally posted by James K

You can use the row_number function or group by clause - in the example below, I am using group by. If you want to see only rows that have duplicates, uncomment the last line

select 
table_name, active, businessunitid, cost_center, glacct, glsubacct, COUNT(*) AS DupCount 
from LAW_DEL_IMGNOW_GLACCT_CHG
GROUP BY 
select table_name, active, businessunitid, cost_center, glacct, glsubacct from LAW_DEL_IMGNOW_GLACCT_CHG
-- HAVING COUNT(*) > 1

---