9 lines
348 B
MySQL
9 lines
348 B
MySQL
|
/*Write a query to display all the information of the employees who does not work in those departments where some employees works whose id within the range 100 and 200.
|
||
|
|
*/
|
||
|
|
|
||
|
|
SELECT *
|
||
|
|
FROM employees
|
||
|
|
WHERE department_id NOT IN
|
||
|
|
(SELECT department_id
|
||
|
|
FROM departments
|
||
|
|
WHERE manager_id BETWEEN 100 AND 200);
|