Home -> Usenet -> comp.databases.oracle -> SQL Query - Selecting records that repeat / occur more than once in a table -- newbe question

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

From: Nimesh <nbsj67_at_yahoo.com>
Date: 11 Feb 2004 18:07:53 -0800
Message-ID: <ec54ea9f.0402111807.477c1edd_at_posting.google.com> 





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 Thu Feb 12 2004 - 03:07:53 CET












Original text of this message