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

SELECT customer_name, Count(*) num_occurances FROM dtb_customer
group by customer_name
having count(*) > 1

will do it..

nbsj67_at_yahoo.com (Nimesh) wrote in message news:<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 - 11:57:30 CET