How to Delete the rows of employees who are working in the company for more ?

Oracle Apps Interview Questions › Category: SQL › How to Delete the rows of employees who are working in the company for more ?
0 Vote Up Vote Down
Questions Master asked 10 years ago

How to Delete the rows of employees who are working in the company for more ?

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 10 years ago

DELETE FROM emp WHERE (sysdate-hiredate)/365>2;