Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.
Say your table looks like this YOUR_table ( col1 number, col2 number, col3 number); And you have duplicate records in it. To get rid of those duplicate records you may try this sql. DELETE from your_table t1 where rowid not in ( select max(rowid) from your_table t2 where t1.col1 = t2.col1 and t1.col2 = t2.col2 and t1.col3 = t2.
