Consider the below is the table name “student”

s_id      name
----     ----
 1    |   a      
 2    |   b    
 3    |   c
 4    |   a
 5    |   d
 6    |   b
 7    |   e

Now there are plenty of duplicate records …