select * from emp full join dept on emp.deptno=dept.deptno where empno is

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 / sivaram pothuru

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

Answer Posted / sivaram pothuru

select * from emp full join dept on emp.deptno=dept.deptno
where empno is null;

Is This Answer Correct ?

4 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

State the difference between local and global temporary tables?

1164

How to create an inline table-valued function?

1019

What is tempdb in sql server?

1026

what are the new features in SSRS?

145

What do you mean by authentication modes in sql server?

1131

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

187

What is the difference between TRUNCATE and DROP?

1184

What is database isolation in sql server? : sql server database administration

1149

What is the purpose of self join?

1035

When we should use and scope of @@identity?

1041

Can coalesce return null?

1062

What do you mean by an execution plan?

1186

What is the use of for clause?

1162

If we delete pack Spec what will be the status of pack Body ?

1522

What are the benefits of filtered indexes?

1094