select Emp_id,Emp_name,Emp_email into newtable from Employee
6 U+ \4 M! Z$ o, | group by Emp_id,Emp_name,Emp_email, P: g; @' H7 j3 F% P
having count(*)>1;
1 l( M6 V' X7 J& i" M; _ ; ~# r, p, r+ i, y7 |* q$ N3 E
delete from Employee( ~8 ~0 I) m" ^$ R+ j0 I) P8 B5 l
where Emp_id,Emp_name,Emp_email in newtable;7 G" D/ c F2 n
4 z6 G0 B! S. u8 o' C
insert into Employee
8 F3 P3 g6 w7 ^: Z select Emp_id,Emp_name,Emp_email from newtable; |