How will you delete duplicate records from a table?
DELETE FROM (
SELECT A, ROW_NUMBER() OVER (PARTITION BY A) AS RN FROM my_table
WHERE RN > 1
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!