Solved programming problem

Show those employee_id s from the job_history table whose total experience is greater than 5 years

Source code

SELECT EMPLOYEE_ID

FROM job_history

WHERE DATEDIFF(END_DATE,START_DATE) > (5*365);
Join the discussion

Add your comment