programming-examples/20. Write a query in SQL to display the employee ID, first name, job id, and department number for those employees who is working except the departments 50,30 and 80.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

292 B

SQL

Raw Permalink Blame History

 /*20. Write a query in SQL to display the employee ID, first name, job id, and department
 number for those employees who is working except the departments 50,30 and 80.*/
 SELECT employee_id, first_name, job_id, department_id
  FROM employees
   WHERE department_id NOT IN (50, 30, 80);