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

preview_player
Показать описание
Oracle SQL PLSQL and Unix Shell Scripting
Рекомендации по теме
Комментарии
Автор

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

Ganeshay-
Автор

this is the best session, I have ever seen

debayanapanigrahi
Автор

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

mohamediqbala
Автор

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

SivaKumar-syvw
Автор

very nice explanation plz keep posting

suneetham
Автор

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

tapasgaan
Автор

sir, is this the example of corelated subquery?

sujeetkakade