Register now or log in to join your professional community.
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 ) ;
use distinct keyword in your query to remove duplication of data. its actually remove duplicated entry in your result set but its does not permanently removed from data base. for example if we write a query like this way
select distinct city from student;
it will fetched all the cities name associated with table student but do not show same city name(e.g kolkata) even it is entered in different row. that means if kolkata city is used for multiple student its does not show kolkata for multiple time as distinct is used
Distinct option is the easiest way to remove Duplicate rows
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.
