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
- 10400 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 does this statement do @@rowcount?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
what are constraints? Explain different types of constraints? : Sql server database administration
What is model database in sql server?
What is store procedure? How do they work?
What are group functions in query statements in ms sql server?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is sql server management studio? : sql server management studio
What do you understand by sql server agent?
What is the difference between truncate and delete commands?
What is the maximum number of index per table?
How do you identify a foreign key?
Explain collation?
How to create database with physical files specified in ms sql server?
What are commit and rollback in sql?
