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

Define Unique Key?

1015

What is the data tier application?

169

What are functions in the sql server?

1220

What are the dmvs?

1014

Can we take the full database backup in log shipping?

955

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1882

How do I create a trace in sql server?

1045

Explain the relational database management system (rdbms)?

1099

How are the exceptions handled in sql server programming?

1065

Write a program using SQL queries to find a unique entry in a table.

995

Disadvantages of the indexes?

1125

Explain the difference between HTTP and HTTPS in database?

1037

Explain what are sparse columns?

993

Write a program to fetch first 10 records from a file?

1012

Will sql server 2005 allow you to reduce the size of a column?

992