SQL Query to List the EMPS in ASC Order of Designations of those JOINED after the second half of a year

LIST THE EMPS IN THE ASC ORDER OF DESIGNATIONS OF THOSE JOINED AFTER THE SECOND HALF OF 1981.

SELECT *
FROM EMP
WHERE HIREDATE > (30-JUN-81)
  AND TO_CHAR(HIREDATE,YYYY) = 1981
ORDER BY JOB ASC;

Comments

Popular posts from this blog

Top myths for NULL value in SQL Queries