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
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