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
- 12138 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 join and name different type of joins?
How many servers can we create in a single subscription?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How do I clean up sql server transaction log?
What is sql collation?
What is function of CUBE ?
What are the types of table?
How to modify an existing stored procedure in ms sql server?
What is the difference between varchar and varchar types?
Can you please explain the difference between primary keys and foreign keys?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is a mixed extent?
How to create a new table in a given schema?
What does the update command do?
What is importing utility?
