Help | Site Map

Join Bytes
Login

network: 226,223 (2692 online)

bytes

Delete Duplicate rows without using ROWID

AdusumalliGopikumar AdusumalliGopikumar is offline

AdusumalliGopikumar is offline

Member

Join Date: Aug 2007

Location: india

Posts: 43

#1: Sep 19 '08

Please can anyone tell me how to delete duplicate rows from a table without using the pseudo column ROWID in the query

Thanks in Advance

debasisdas debasisdas is offline

debasisdas is offline

Moderator

Join Date: Dec 2006

Location: Bangalore ,India

Posts: 7,497

#2: Sep 19 '08

re: Delete Duplicate rows without using ROWID

you have to use ROWID for that.

Reply

« previous question | next question »

Similar Oracle Database bytes

Delete a Row in Excel Spreadsheet (answers)
How to delete rows in a table when no primary key is defined (answers)
DELETE query syntax using subqueries (answers)
unable to delete duplicate records in database (answers)

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,223 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml

it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved