query to remove duplicate records in postgresql server
snippet in sql

query to remove duplicate records in postgresql server

user8885


        
            
        
     DELETE FROM
    basket a
        USING basket b
WHERE
    a.id < b.id
    AND a.fruit = b.fruit;