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
- 10847 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vinoth kumar
select * from department where Dept_id
not in(select Dept_id
from employee)
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Define Unique Key?
can a database be shrunk with users active? : Sql server administration
What is the difference between grant and with grant while giving permissions to the user?
What is the use of sql profiler in sql server 2012?
How to retrieve field values using mssql_result()?
When should you use an instead of trigger?
How do I start sql server 2017?
What are out-of-range errors with date and time literals?
Define right outer join?
What is checkpoint in sql server?
Can foreign key be duplicate?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Do you know exporting and importing utility?
What is statement level trigger?
How do I uninstall sql server 2014?
