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
- 11829 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
List out the differences between the clustered index and non-clustered index in sql server?
What are the types of user defined functions in sql server?
What is the recursive stored procedure in sql server?
Explain sql delete command?
How to store and query spatial data?
What is use of except clause?
What is a performance monitor?
How do I open a .db file?
What do you mean by an execution plan? Why is it used?
Explain the properties of sub-query in sql server?
Define outer join in sql server joins?
What is normalization 1nf 2nf 3nf?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Explain trigger and trigger types?
Write a query to find 5th highest amount paid from the customer table.
