delete from tblname where rowid not in (select max(rowid) from tblname group by columnA, columnB);
Open in new window
Get your personalized solution.
Please provide your email to receive a sample view!
*This site is protected by reCAPTCHA and the Google
Terms of Service apply.
Please enter a first name
Please enter a last name
8+ characters (letters, numbers, and a symbol)
Take hold of your future.