Question

Write a query to display name, job,salary and hiredate of employees who are hired between may 20,1990 and December 31, 1991 . Order the query in ascending order of hiredate.

Answer 1

Answer:

SELECT name, job,salary , hiredate FROM EMPLOYEE WHERE hiredate IS BETWEEN "MAY 20,1990" TO "DEC 31,1991" ORDER BY HIREDATE;