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
Post a Comment