Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12298 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sql pro
/*stored procedure for emplpoyee and department table
to get DeptName which has no employee records*/
select d.dept_name
from dept d
left join empl e
on d.dept_id = e.dept_id
where e.dept_id is null
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is cube dimension? : sql server analysis services, ssas
What are the types of processing and explain each? : sql server analysis services, ssas
How do I create an extended event in sql server?
What functions can a view be used to performed?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What happens on checkpoint?
Explain what is “asynchronous” communication in sql server service broker?
How to rebuild the master database?
How will you decide the active and passive nodes?
What do you mean by an execution plan?
What is the report builder?
What is the use of sql profiler in sql server 2012?
what is an extended stored procedure? : Sql server database administration
How many types of schemas are there?
How do I determine how many instances of sql server are installed on a computer?
