SQL Query - Selecting records that repeat / occur more than once in a table -- newbe question

I need to find customer's names that repeat / occur more than once in the same table. I have treid many options and I have tried comparing the column to itself but Oracle gives me an error.

SELECT a.customer_name, b.customer_name FROM dtb_customer a, dtb_customer b
where a.dtb_customer = b.dtb_customer
and b.customer > 1

Any help would be appreciated.

Thanks in advance. Received on Wed Feb 11 2004 - 20:07:53 CST