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
- 11819 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
Do I need a report server to run reports in my application?
Where the sql logs gets stored? : sql server database administration
Tell me what is a linked server?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Can we delete data from a view?
What is the difference between join and inner join?
What is sql view?
Can we write trigger for view?
Can you explain important index characteristics?
How to generate random numbers with the rand() function in ms sql server?
can SSRS reports Cache results?
Which database stores information about replication?
explain different types of cursors? : Sql server database administration
Tell me what is normalization? Explain different forms of normalization?
How can you manage sql azure security?
