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
- 10403 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
What does man by sql wildcard characters in sql server?
Is it possible to have clustered index on separate drive from original table location?
How to get the query of a table in sql server?
What is server-level principal?
What are recommended options to be used while using db mirroring? : sql server database administration
What is hot add cpu in sql server 2008?
Why transaction is important?
What is history table in sql server?
Tell me what is the significance of null value and why should we avoid permitting null values?
What is the security principal at the server level that represents your session?
What functions can a view be used to performed?
What are partitioned views and distributed partitioned views?
How do I uninstall sql server 2014?
When is update_statistics command used?
What is the contrast between sql and pl/sql?
