Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL for getting duplicate records?
select * from table a
/*at least one condition */
where field=a.field
/* maybe others */
/* and field2=a.field2
...
*/
and rowid !=a.rowid
..
Rich Gilmour wrote in message <7ovh1i$3j1$1_at_nusku.cts.com>...
>
>Hi all.
>
>Forgive me if this sounds really stupid, but I'm new to SQL. Could somebody
>please explain how to properly contsruct a SQL statement that returns all
>records in a table with matching field values? I've managed to pull
distinct
>values, but thats not what I'm after.
>
>Thanks in advance,
>
>RIch Gilmour
>
>
Received on Thu Aug 12 1999 - 17:47:15 CDT