Category Archives: SQL CTE

SQL CTE

Deleting Duplicate rows using CTE

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 … Continue reading

Posted in Interview Questions, SQL Advanced, SQL CTE, SQL Server | Tagged | 26 Comments

CTE command In Sql Server

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 … Continue reading

Posted in Most Imp SQL Concepts, SQL CTE, SQL Server | Tagged , | 31 Comments