DB2 - Display the employee details who are working from more than 1 and half year

 Posted by Bandi on 11/30/2013 | Category: Others Interview questions | Views: 1429 | Points: 40
Answer:

SELECT * FROM EMPLOYEES WHERE DAYS (CURRENT_DATE)-DAYS (HIRE_DATE) >548

(OR)

SELECT * FROM EMPLOYEES WHERE HIRE_DATE < (CURRENT_DATE - 1 YEARS - 6 MONTHS)


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response