get who is hired in month in sql code example
Example: get who is hired in month in sql
BY EXTENDING ABOVE QUERY , FIND OUT EVERYONE WHO IS HIRED IN JAN
SELECT FIRST_NAME , HIRE_DATE
FROM EMPLOYEES
WHERE SUBSTR(HIRE_DATE, 4, 3) = 'JAN' ;
BY EXTENDING ABOVE QUERY , FIND OUT EVERYONE WHO IS HIRED IN JAN
SELECT FIRST_NAME , HIRE_DATE
FROM EMPLOYEES
WHERE SUBSTR(HIRE_DATE, 4, 3) = 'JAN' ;