Home » SQL & PL/SQL » SQL & PL/SQL » Delete Duplicates
Delete Duplicates [message #229885] Tue, 10 April 2007 04:23 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hi

I want a query .Remove duplicates records in atable (without using rowid nad rownum).

anybody...

Arun..
Re: Delete Duplicates [message #229887 is a reply to message #229885] Tue, 10 April 2007 04:26 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
akkumar81 wrote on Tue, 10 April 2007 11:23
Hi

I want a query .Remove duplicates records in atable (without using rowid or rownum).

anybody...

Arun..
Why? What database/version are you on?

MHE

[Updated on: Tue, 10 April 2007 04:26]

Report message to a moderator

icon7.gif  Re: Delete Duplicates [message #229891 is a reply to message #229887] Tue, 10 April 2007 04:40 Go to previous message
nagendra.dasari
Messages: 1
Registered: April 2007
Location: HYD
Junior Member

Hello Friend,

Go With "Check" Constan., else Befoure creating the table provide Primary Key to the selected colomn .
Previous Topic: help with analitycal functiol
Next Topic: updating null column
Goto Forum:
  


Current Time: Sun Dec 04 16:58:38 CST 2016

Total time taken to generate the page: 0.23197 seconds