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
- 9957 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sivaram pothuru
select * from emp full join dept on emp.deptno=dept.deptno
where empno is null;
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is the purpose of self join?
How to connect php with different port numbers?
Explain the first normal form(1nf)?
What to perform pattern match with the like operator?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What are secondary xml indexes?
Explain “@@rowcount” and “@@error” in sql server?
How check triggers in sql server?
List out different types of normalizations in sql server and explain each of them?
What is isolation levels?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is command parameter in ssrs?
How to insert multiple rows with a subquery?
What is serializable?
How do you test your database? : sql server database administration
