Delete Duplicate Rows from SQL Table using 3 ways

In This Tutorial you will learn how to Delete duplicate rows in SQL Server
GetsetSQL Blog: www.getsetsql.com
KZbin Channel: / getsetsql
Facebook: / getsetsql
Quora: www.quora.com/Amitesh-Bi/
Twitter: / getsetsql
Twitter: / amiteshdba
LinkedIn Group: / 10541375
LinkedIn Profile: / amitesh-srivastava
Music: Music: www.bensound.com

[@dshantanub27]

best explanation ever bro. You won't believe I was not understanding this concept untill I saw this video. TYSM bro

[@relangirama]

nice explanation

[@sukumar44]

Important advice for everyone watching this video: Please don't use the temporary table way to delete duplicates. By any chance, if your session is timed out you will loose all your data(backup). I have seen this happening in live projects. It not a good practice to truncate your main tables either.

[@Chadner]

Thats what I thought too, even though it is the easier way it does feel reckless to just dump everything without a safe backup. What about creating a new real table with the same attributes, then copying the data to it and only then dropping the original table?

[@movingcloud5253]

Nice one 👍👍👍👍👍❤️❤️❤️

[@shashanksingh3838]

it's throwing an error: Error Code: 1288. The target table remove_duplicate of the DELETE is not updatable

[@jeetendrasahani1428]

when use insert into table _name select * from # table _name - it is showing error like not supply and match values

[@karandholakia1555]

Which tool is this to run queries ?

[@Amitesh.Shrivastava]

SQL Server Management Studio

[@RoarMaddy]

Can we use rowid to delete duplicate?

[@GetSetSQL]

sure we can use rowid to delete duplicate records .. this can be achieved by using subquery or CTE

[@user-vl4tp5sw2e]

What is the application u use?? Thanks

[@GetSetSQL]

Which?

[@mettupallimuneendrareddy9753]

Waste