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
- 10401 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / unnikrishnan nair r
CREATE PROCEDURE GetDept
AS
SELECT Dept_name from dept
WHERE Dept_Id NOT IN(SELECT DISTINCT Dept_id FROM Emp )
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is an example of a foreign key?
What is default port number for sql server 2000?
What is table join?
How and why use sql server?
What do you understand by the analysis services in sql server?
Explain trigger and its types?
what are database files and filegroups? : Sql server database administration
What is default constraint?
What are the different types of collation sensitivity?
What are synonyms?
What is the correct order of the logical query processing phases?
What is built-in/administrator?
what is difference between view and Dip.
what's new in sql server 2016?
What are the types of dml?
