CareerCup

select Emp_id,Emp_name,Emp_email into newtable from Employee
group by Emp_id,Emp_name,Emp_email
having count(*)>1;

delete from Employee
where Emp_id,Emp_name,Emp_email in newtable;

insert into Employee
select Emp_id,Emp_name,Emp_email from newtable;

delete *
from (select * from emp MINUS select distinct(emp_id, emp_name, emp_mailid) from emp)

delete from employee e1 where e1.rowid in
(
select e2.rowid from employee e2 where
e1.empid = e2.empid and
e1.rowid > e2.rowid
)

sort on empid key and compare

delete from Employee where rowid in (
  select rid from (
    select rowid rid, 
           row_number() over(partition by id,name,email order by id,name,email) as idx 
    from tab7)
  where idx>1);

delete from employee a
     where a.rowid > ANY(select b.rowid
                                          from employee b
                                          where a.empid = b.empid)

you can use this:

select * from Employee group by Emp_id,Emp_name,Emp_email;

delete from Employee 
where rowid not in (
select min(rowid) from Employee group by Emp_id
)

How does a query delete something?

how about select distinct * from from Employee

how about select distinct * from Empolyee