Bhupendra Singh

Bhupendra Singh

  • NA
  • 225
  • 149.3k

how to delete duplicate record in tables ?

May 1 2013 2:45 PM
I have a emp table.It`s have 1000 records.

Empid Name Department 1 AA IT 2 AB SALES 3 AA IT

1 AA IT 2 AB SALES 4 CC MR

1 AA IT


I want to delete duplicate record.

Table take only one record of every person

Output of record
like
Empid       Name       Department
1            AA        IT 
2            AB        SALES 
3            AA        IT
4 CC MR


Answers (2)