Tag Archives: SQL CTE

Deleting Duplicate rows using CTE

By | December 29, 2013

Many times we caught in a situation where we have a table where there is no primary or unique column defined in it and rows with duplicate data inserted in the table. In this example I will tries to show how to delete the duplicate rows using CTE. Suppose we have a table name “tbl_dublicatedata”… Read More »