top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

Oracle: How display the names of employees who are working in the company for the past 5 years?

0 votes
1,791 views
Oracle: How display the names of employees who are working in the company for the past 5 years?
posted Jun 12, 2015 by Kunal Kapoor

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button
Will this logic be sufficient for leap year

1 Answer

0 votes

Select employeename from employee where sysdate-hiredate>5*365;

answer Jun 17, 2015 by Manikandan J
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...