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
- 12326 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 is transact-sql language?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Where can you find the error log information? : sql server database administration
Are null values the same as that of zero or a blank space?
What are the security related catalog views? : sql server security
Can you get second highest salary from the table?
What happens when transaction log is full?
What is BCNF? How is it better than 2NF & 3NF?
Which autogrowth database setting is good?
What is a ddl statement?
Explain syntax for dropping triggers?
List all types of constraints in sql server?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is subquery in sql?
What do you understand by replication in sql server?
