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
- 7 Answers
- 10845 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
What is transaction server isolation?
How do I determine how many instances of sql server are installed on a computer?
Which are new data types introduced in sql server 2008?
What is difference between unique and primary key?
Explain about thread and memory management process of SQL?
What is database mirroring?
Explain the flow of creating a cube? : sql server analysis services, ssas
What is the standby server?
What is database replication?
What is key attribute?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What is the recommended total size of your memory optimized tables?
Explain what are the authentication modes in sql server?
Can we return Data from 4(more than 1) tables in stored procedure?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
