ramji

ramji

  • NA
  • 38
  • 4.9k

duplicate records

Sep 24 2015 5:50 AM
i want to remove records which are repeated more then once.
 
i have one table having three columns.In this table lot of duplicate records are there.
i want to delete all the duplicate records.for example i created one table i put
some sample records.please find the sample records. 
 
id                   no    sequence
 
35                35432     1
35                35432     2
35                35432     3
36                35432     1
 
i want to delete all the records of  id=35.i want the record of only id=36.

Answers (7)