How to Delete Duplicate Records From Country Table?
Can you please help me to write a query to Delete Duplicate Records From Country Table?
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.
Let us take 3 columns ID, Name and Code from the country table. You can write a query something like.
With CTE as
Select Gender, Salary, row_number() over ( order by Gender ) as rownum
Delete from employees where rownum>1;