Tech Study

How can I remove duplicate rows from large table

Introduction

Remove duplicate rows from large table which has more than 10,000+ rows.

DELETE FROM student 
WHERE ID NOT IN (SELECT MIN(ID) 
                    FROM student 
                    GROUP BY Col1,Col2,Col3)

 

TaggedHow can I remove duplicate rows from large table

Java Final keyword

Introduction : java final keyword The final keyword present in Java programming language is generally used for restricting the user. …

Read more

C++ Memory Management: new and delete

C++ Memory Management We know that arrays store contiguous and the same type of memory blocks, so memory is allocated …

Read more