need fast SQL Statement for find and delete duplicate entrys
Budget: €8 – €30 EUR
i got a table with
id,datastoreid,productnumber
the id is the key
now i got in the datastoreid column the same entry some times. Here i need to find the duplicate entrys and delete them so that at the end i got just 1 of each datastoreid
id,datastoreid,productnumber
the id is the key
now i got in the datastoreid column the same entry some times. Here i need to find the duplicate entrys and delete them so that at the end i got just 1 of each datastoreid