I have a emp table.It`s have 1000 records.Empid Name Department 1 AA IT 2 AB SALES 3 AA IT1 AA IT 2 AB SALES 4 CC MR1 AA ITI want to delete duplicate record.Table take only one record of every personOutput of record likeEmpid Name Department 1 AA IT 2 AB SALES 3 AA IT4 CC MR
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 personOutput of record
like
Empid Name Department 1 AA IT 2 AB SALES 3 AA IT4 CC MR
Empid Name Department 1 AA IT 2 AB SALES 3 AA IT
4 CC MR