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.