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
- 10402 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sivaram pothuru
select a.*,d.* from dept a
left join emp d on a.deptno=d.deptno where d.deptno is null
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What the different topologies in which replication can be configured?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is indexing in sql server with example?
What are SSL and TSL protocols?
What is user defined stored procedures?
What is subquery explain with example?
Explain the difference between function and stored procedure?
How you provide security to cube? : sql server analysis services, ssas
What is temporary stored procedure?
How to create a ddl trigger using "create trigger" statements?
How can you list all the table constraints in a database?
How does a profiler work?
How can you insert null values in a column while inserting the data?
Is there any difference between the primary key and unique key?
How to resolve the orphan use problem? : sql server security
