Skip to main content
Code To HaveN
Toggle navigation
Home
Categories
Online Judge
YouTube Tutorials
About
Search tutorials and solutions
Search
Categories
/
MySQL
/
Operator
Solved programming problem
Show those employees details who is not assigned to the department_id 100 or 30 or 90
Source code
Copy code
SELECT * FROM employees WHERE DEPARTMENT_ID NOT IN(100,30,90);
Join the discussion
Add your comment
Your name
Comment
Post comment
Add your comment