SQL CTE Archives - Technology with Vivek Johari

Deleting Duplicate rows using CTE

December 29, 2013January 28, 2019 vivekjohari26 Comments

Deleting Duplicate rows using CTE 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 […]

CTE command In Sql Server

January 17, 2012February 1, 2019 vivekjohari31 Comments

Common table expression (CTE):- Common table expression or CTE can be described as the temporary, named record set return by the execution of the query (insert, delete, update, select or update view statement). It is not stored as an object in the database and it last only till the execution of the SQL Query. It […]