DB2 - Display the LAST_NAME and HIRE_DATE of every employee who was hired in 2006

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

SELECT LAST_NAME, HIRE_DATE
FROM EMPLOYEES
WHERE YEAR(HIRE_DATE)=2006


SELECT LAST_NAME, HIRE_DATE
FROM EMPLOYEES
WHERE HIRE_DATE LIKE '2006%'


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response