Web Analytics Made Easy - Statcounter

SQL CTE

Deleting Duplicate rows using CTE

by
blank

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 … Read more

CTE command In Sql Server

by
SQL Server CTE

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 … Read more