Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the easiest way to remove duplicate rows in a table ?

SQL
user-image
Question added by Amine Abdallah Doukara , 1 , Sonatarch
Date Posted: 2016/02/24
Upvote (0) Views (7) Followers (3) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Amine Abdallah Doukara
by Amine Abdallah Doukara , 1 , Sonatarch

easiest way  using close group by and having:

 

exemple: table T1 with  colomn A

DELETE     T1 WHERE     A    IN (                SELECT    A                FROM       T1                GROUP BY  A                HAVING       COUNT (*)     > 1              ) ;

Dineshkumar Murugesan
by Dineshkumar Murugesan , SoftwareEngineer , EasyDesignSystems.Pvt Ltd

Distinct  option is the easiest way to remove Duplicate rows

Write Your Answer
More Questions Like This