Re: Duplicated Row Queries

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/03/01
Message-ID: <89i6ka$j65$2@perki.connect.com.au>#1/1

well,
Consider that you have a table like
create table MyTab(

    name varchar2(6)
    address varchar2(10)
    );

insert into MyTab values('You','There');
insert into MyTab values('Me','Here');
insert into MyTab values('Me','Here');

select a.name, a.address from MyTab a, MyTab b where a.name=b.name and
a.address=b.address and
a.rowid<>b.rowid

The above code will only select records which their name and address are the same.

You could use this logic for almost any table.

Tom

Niels Lippke <c0032019_at_tu-bs.de> wrote in message news:Pine.HPX.4.10.10002291110410.3495-100000_at_rznb1.rz.tu-bs.de...

Hi,

I need to find these rows in my table, that appear more than one time. But I don´t know how to construct a SQL-Query that returns
these rows.

Anyone can help?

Thank you in advance,

Niels

---

Niels Lippke
Technische Universitaet, Braunschweig
Gruppe Verwaltung und Planung Received on Wed Mar 01 2000 - 00:00:00 CST