Tag: SQL server

Delete duplicate rows from SQL table

Delete duplicate rows from SQL table. How to delete duplicate rows without a primary key? Select only unique rows using CTE.  For the demonstration purpose, I have created a dummy database […]

SQL interview questions part 1

What is SQL function? SQL functions are methods which accept parameters and perform the action, such as a complex calculation and return the result of that action as a value.the […]

What is Row_Number() in SQL ?

Hello everyone, today I am going to discuss the Row_number feature in SQL server. what is Row_Number()? Row_Number is used to generate the number of each row dynamically in a […]