!!!DB2 重複業を削除
[DB2][Database]{{category SQL}}

{{amazon 4873113156}}
*同一部署の先頭の従業員NO以外を削除 
 delete from employee
 where empno not in ( 
    select min(empno) from employee_tmp group by workdept
 )