Re: Identifying duplicate records

From: T <t_at_yahoo.com>
Date: Wed, 8 Mar 2006 08:46:47 +0100
Message-ID: <dum27n$q30$1@ss405.t-com.hr>

<simpsonj_at_imsweb.com> wrote in message
news:1141667439.835557.55200_at_j33g2000cwa.googlegroups.com...
> Hi everyone, I have a table that contains duplicate records. All of
> the fields in these records are duplicates except for the primary key.
> I need to identify these records by their primary key. Can anyone help
> me with this? Thanks ahead of time.
>

Read more about ROWID pseudocolumn,
or try
Select field1, field2, rowid a from table 1 Received on Wed Mar 08 2006 - 01:46:47 CST