SQL Interview Questions | Collect employee details

Question
empid empname managerid deptid Salary
1 Emp1 0 1 6000
2 Emp2 0 5 6000
3 Emp3 1 1 2000
13 Emp13 2 5 2000
11 Emp11 2 1 2000
9 Emp9 1 5 3000
8 Emp8 3 1 3500
7 Emp7 2 5 NULL
3 Emp3 1 1 2000

Can you get employee details whose department id is not valid or department id not present in the department table?

in progress 0
Dhruv2301 4 years 4 Answers 930 views Great Grand Master 0

Answers ( 4 )

  1. select * from Emp where deptid
    NOT IN (select deptid from Dept)

  2. select * from emp where deptid not in (select deptid from department);

  3. select *from employee
    where deptid NOT IN ( Select Dept Id from Department Table)

  4. select * from employees where dept_id is null;

Leave an answer

Browse
Browse