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

Python Examples

Introduction: Python Examples are the basic programming concepts of python like python syntax,python data types,,python operators,python if else,python comments etc.. …

Read more

C String Functions

C String Functions perform certain operations, It provides many useful string functions which can come into action. The <string.h> header …

Read more