select * from department where Dept_id not in(select Dept

Write a stored procedure for emplpoyee and department table
to get DeptName which having no employee.
Table Structure-
Emp-Emp_Id,Emp_Name,Dept_id
Dept-Dept_Id,Dept_Name

Question Posted / vinoth kumar

7 Answers
12029 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / vinoth kumar

select * from department where Dept_id
not in(select Dept_id
from employee)

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why I am getting this error when dropping a database in ms sql server?

1061

What is indexed view?

968

What is tempdb in sql server?

951

What is in place upgrade in sql server?

1027

Determine when to use stored procedure to complete sql server tasks?

1037

what is a transaction and what are acid properties? : Sql server database administration

1009

Explain having clause?

950

How do database indexes work?

995

What is the difference between local and global temporary tables?

1128

Why would you call update statistics?

1001

What is field in algebra?

1012

How can we check the sql server version?

1036

How to optimize stored procedure optimization?

881

What do you understand by mirroring and mention the advantages of the mirroring?

1047

What is unpivot?

1001