Oracle Find duplicate records and delete the duplicated records retaining one of duplicated value

Oracle SQL PLSQL and Unix Shell Scripting

[@Ganeshay-996]

finaly i got best channel about sql plsql ..super hero

[@debayanapanigrahi8121]

this is the best session , I have ever seen

[@Estilo300]

Nice

[@lastchance4846]

thank you so much, it works!!

[@naveend2475]

Well explained thanks

[@suneetham7143]

very nice explanation plz keep posting

[@sridharraghavan4120]

Thank you

[@uddhavjadhav3344]

Thanks very much

[@tapasgaan7371]

If u group by sno only, then will this work if one sno is having two names...what I mean is if two records are as follows 101, Shelly and 101, Trevor and sno is not primary key

[@sujeetkakade6053]

sir,is this the example of corelated subquery?

[@vamsikrishna-sj5bq]

nice ...can we rearrange the rowid

[@mohamediqbala5013]

Thanks for the video.. will it delete the other rows which are not duplicate at all.?

[@SivaKumar-sy6vw]

Great explanation. please help me how can I write a query if i want to delete specific duplicates not all duplicates

[@KAAO-zc8tc]

Using where condition we write

[@KAAO-zc8tc]

Ex:delete from empire where id=2