This tip is one of my favorite. Many times you found this problem you table records are duplicate due to various reason and you want to rid of duplicate records. Lets understand this with an example Suppose, I have a table which content duplicate rows. In my example I took a temporary table variable …