Re: newbie - duplicate rows

From: Alan Slay <theslays_at_mindspring.com>
Date: 1998/01/14
Message-ID: <34bc418f.1102915_at_news.mindspring.com>#1/1


Several ways. A quick one I use just to see a list is:

select col1, col2, col3, count(*)
from t_table_name
group by col1, col2, col3
having count(*) > 1;

where col1, col2, col3 are the items that should be unique.

If I want to do some processing on this list (i.e. delete one of them) I will use this same SQL in a cursor within PL/SQL and fetch the rows out one at a time and do my processing.

"Hung Binh" <bhung_at_netbuyparts.com> wrote:

>How do I query all duplicated rows in a table?
>
>Thanks
Received on Wed Jan 14 1998 - 00:00:00 CET

Original text of this message