Re: Duplicated Row Queries

From: <jeanch_at_my-deja.com>
Date: 2000/02/29
Message-ID: <89gdk9$kt5$1@nnrp1.deja.com>#1/1

In article <Pine.HPX.4.10.10002291110410.3495-100000_at_rznb1.rz.tu-bs.de>, Niels Lippke <c0032019_at_tu-bs.de> wrote:
>
> Hi,=20
>
> I need to find these rows in my table, that
> appear more than one time. But I don=B4t know how
> to construct a SQL-Query that returns
> these rows.=20
>
> Anyone can help?
>

I'm not sure I understand what you want but to my knowledge the default behaviour of select will return all including duplicates; ie SELECT * tab WHERE COL = condition; you also could fetch ROWID select rowid from tab where col = condition Now don't distinct cause it will remove duplicates.

If i misunderstood what you want please give us more hints.

Cheers
JC

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 29 2000 - 00:00:00 CST