Delete the rows of employees who are working in the company for more than 2 years.

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 1365
delete from emp where (sysdate-hiredate)/365>2;

Comments or Responses

Login to post response