Sunday, 15 November 2026

Find employees who don’t have a department assigned.

Let's create table schema and sample data.

Table Schema and sample data:-

CREATE TABLE departments (
  id INT PRIMARY KEY, 
name VARCHAR(50) NOT NULL 
); 

CREATE TABLE employees (
  id INT PRIMARY KEY, 
name VARCHAR(50) NOT NULL, 
department_id INT, 
FOREIGN KEY (department_id) REFERENCES departments(id) 
); 

INSERT INTO departments (id, name) VALUES 
(10, 'Engineering'), (20, 'Sales'), 
(30, 'HR'); 

INSERT INTO employees (id, name, department_id) VALUES 
(1, 'Asha', 10), (2, 'Ravi', 20), 
(3, 'Meera', NULL), 
(4, 'Kiran', 30), 
(5, 'Neha', NULL);

Query:-

SELECT * 
FROM employees 
WHERE department_id IS NULL;

No comments:

Post a Comment

Note: only a member of this blog may post a comment.