Agar aapko har duplicate id me se sirf ek row rakhni hai, to yeh query use karein 👇

 Agar aapko har duplicate id me se sirf ek row rakhni hai, to yeh query use karein 👇

WITH cte AS (
    SELECT *,
           ROW_NUMBER() OVER (PARTITION BY id ORDER BY (SELECT 0)) AS rn
    FROM your_table
)
DELETE FROM cte WHERE rn > 1;


Particular Entry ke liye
WITH cte AS (
    SELECT *,
           ROW_NUMBER() OVER (PARTITION BY id ORDER BY (SELECT 0)) AS rn
    FROM your_table
    WHERE id = 5676
)
DELETE FROM cte WHERE rn > 1;