programming-examples/32. Write a query in SQL to display the employee ID and the date on which he ended his previous job.sql at master - programming-examples - michuIT: Everything is code

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

4 lines

204 B

SQL

Raw Permalink Blame History

 /*32. Write a query in SQL to display the employee ID and the date on which he ended his previous job.*/
     SELECT employee_id, MAX(end_date)
     FROM job_history
         GROUP BY employee_id;