How to delete duplicate rows from a table ?

[peprasanth]

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

[urtechguru]

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

[urtechguru]

u can use where statement to delete duplicate rows.

[zamu84]

Hi u can delete the duplicate rows by using the function rowid
it shows unique id for each row, so that user can delete it very easily.


Thanks & Regards

Zamu

[shadyfos]

Delete from table
where department_id = 30

[shadyfos]

Delete from employees
where department_id = 30
order by department_id

[shadyfos]

You use the where clause to specify rows to be deleted