Notifications

Clear all

How to Delete Duplicate Records From Country Table?

Last Post

RSS

Posts: 47

Rakesh

Guest

Topic starter

Jul 28, 2020 3:59 am

(@Rakesh)

Eminent Member

Joined: 4 years ago

Can you please help me to write a query to Delete Duplicate Records From Country Table?

Topic Tags

countrytableduplicatereco eliminateduplicatessql

3 Replies

Posts: 27

KV Kumar

Admin

Jul 28, 2020 11:09 am

(@vinodkrsetty)

Eminent Member

Joined: 5 years ago

Check this article https://www.sqlqueries.in/how-to-delete-duplicate-rows-from-a-table/ to know how to delete duplicate records in a table.

Posts: 36

Janani T

Guest

Jul 29, 2020 7:15 am

(@Janani T)

Eminent Member

Joined: 4 years ago

Let us take 3 columns ID, Name and Code from the country table. You can write a query something like.

Select ID, Name, Code, Count(*) as CNT

From Country

Group By ID, Name, Code

Having Count(*)=1

Posts: 47

Info User 1

Guest

Topic starter

Aug 07, 2020 11:12 am

(@Info User 1)

Eminent Member

Joined: 4 years ago

With CTE as

(

Select Gender, Salary, row_number() over ( order by Gender ) as rownum

From employees

)

Delete from employees where rownum>1;