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
SQL
4 years
4 Answers
930 views
Great Grand Master 0
Answers ( 4 )
select * from Emp where deptid
NOT IN (select deptid from Dept)
select * from emp where deptid not in (select deptid from department);
select *from employee
where deptid NOT IN ( Select Dept Id from Department Table)
select * from employees where dept_id is null;