Solved programming problem

Show each employees first_name, department_id, manager_id and his modified join_date that is one week before the his real join_date

Source code

SELECT FIRST_NAME,DEPARTMENT_ID,MANAGER_ID,DATE_ADD(HIRE_DATE,INTERVAL -7 DAY)

FROM employees;
Join the discussion

Add your comment