How to delete duplicate rows ?

devquora
devquora

Posted On: May 26, 2021

 

For deleting the duplicate rows we can do the following:

  • Find duplicate rows using GROUP BY clause or ROW_NUMBER() function.
  • Use DELETE statement to remove the duplicate rows.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Capgemini Java interview questions

    What is database normalization? Explain types of it.

    In SQL, normalization of data is a process through with data is organized in tables used for the reduction of redundancy and dependency of data. It divides large tables into smaller ones using some se...

    Capgemini Java interview questions

    What is difference between Class and object In JAVA?

    Difference between Class and object In JAVA:Class - A class is like a blueprint. It is the class with the help of which objects are created. The class holds together data and methods in one single...