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
12310 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

What is the difference between sdf and mdf?

1352

What are the source of constraints?

979

What is difference between index seek vs. Index scan?

1200

How to connect to a sql server using odbc_connect()?

1203

What is built-in function?

1059

How to link tables in sql server?

976

What is the difference between resultset and resultsetmetadata?

1030

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1052

What is dynamic cursor in SQL SERVER?

1138

What is the default server name for sql server?

1235

What happens if you delete a table that is used by a view?

1061

What is the maximum size per database for sql server express?

1103

Explain Geography datatype in SQL Server

1192

What is the maximum rows in sql server table?

964

How to create hyperlink from returned sql query ?

1183