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 … Continue Reading Delete duplicate rows from SQL table
T-SQL or Transact-SQL is a proprietary SQL extension (design query language). Additional features include high performance, maximum functionality, and greater globalization support. Transaction SQL is a Microsoft SQL Server process … Continue Reading Let’s understand the Transact-SQL
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 … Continue Reading SQL interview questions part 1
Hello everyone, In this article, we will focus on the Domain model an foundation of Domain Driven Design. Domain Model is a term you will hear a ton of Domain … Continue Reading Domain model in Domain driven design
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 … Continue Reading What is Row_Number() in SQL ?