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
- 11836 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 is blocking?
Explain isolation levels that sql server supports?
What are three major types of constraints?
How to create function without parameter in sql server?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What are the advantages of the mirroring?
Define union, union all, minus, intersect?
What command would you use to add a column to a table in sql server?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What is best institute to Learn DotNET And SQL in chennai?
Explain log shipping and mention its advantages.
What is trigger explain with program?
what are constraints? : Sql server database administration
How to write a query with a left outer join in ms sql server?
What are synonyms?
