DB2 - Display the employee LAST_NAME, DEPARTMENT_ID and HIRE_DATE of employees hired between May 1st 2003 and March 30th 2005. Order the query in ascending order by HIRE_DATE

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

Answer:

SELECT LAST_NAME, DEPARTMENT_ID, HIRE_DATE
FROM EMPLOYEES
WHERE HIRE_DATE ‘2003-05-01’ AND ‘2005-03-30’
ORDER BY HIRE_DATE

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : DB2 - Display the LAST_NAME and HIRE_DATE of every ...

Next > : DB2 - Display the LAST_NAME concatenated with DEPA ...

More Interview Questions by Bandi

Latest Interview Questions