programming-examples/22. Write a query in SQL to display the ID for those employees who did two or more jobs in the past.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.

5 lines

220 B

SQL

Raw Permalink Blame History

 /*22. Write a query in SQL to display the ID for those employees who did two or more jobs in the past.*/
 SELECT employee_id
     FROM job_history
         GROUP BY employee_id
             HAVING COUNT(*) >=2;