How to delete duplicate rows from a table ?

peprasanth · #1 (**permalink**) 06-18-2008, 12:14 AM

how to delete duplicate rows from a table with out using rowid?

urtechguru · #2 (**permalink**) 06-28-2008, 10:36 AM

u can use WHERE statement to remove duplicate rows
as:
delete from employees
where department_id =30;

urtechguru · #3 (**permalink**) 06-28-2008, 10:41 AM

u can use where statement to delete duplicate rows.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
delete the duplicate	sandeeppradhan	SQL Server	2	04-23-2008 05:23 AM
duplicate rows	bobby21	SQL Server 2005 Tutorials	5	04-22-2008 02:47 AM
General Ledger – Technical	dongta_ndh	Oracle Apps	0	12-20-2006 11:06 PM
How to delete duplicate rows from a table	athermaliq	Oracle Tutorials	5	01-17-2006 01:03 AM
[FAQ] FileMaker Pro - database for Macintosh and Windows	Martin Trautmann	Tech FAQ	0	04-17-2004 08:26 AM