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
- 10849 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 are transactions in sql?
what happens on checkpoint? : Sql server database administration
What is ms sql server service broker?
what method you can use to reduce the overhead of Reporting Services data sources?
How each E-R model constructs can be mapped to the relational model?
How to provide column names in insert statements in ms sql server?
Explain how to integrate the ssrs reports in application?
How to name query output columns in ms sql server?
Explain nested join?
How to convert character strings into numeric values?
How do triggers work?
Does an index slow down updates on indexed columns?
Why do we use non clustered index?
How to convert numeric values to integers in ms sql server?
Can you force a query to use a specific index?
