Answer / madhuparna bhaumik

/*stored procedure for emplpoyee and department table
to get DeptName which having no employee*/

CREATE PROCEDURE sp_myStoredProcedure
AS
select * from emp full join departments on
emp.department_id=departments.department_id
where employee_id is null;
Go

Answer / vinoth kumar

select * from department where Dept_id
not in(select Dept_id
from employee)

Answer / ayush

create proc DeptName
begin
select * from emp full join dept on emp.deptno=dept.deptno
where empno is null;
end

Answer / sivaram pothuru

select * from emp full join dept on emp.deptno=dept.deptno
where empno is null;

Answer / unnikrishnan nair r

CREATE PROCEDURE GetDept
AS
SELECT Dept_name from dept
WHERE Dept_Id NOT IN(SELECT DISTINCT Dept_id FROM Emp )

Answer / 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

Answer / sivaram pothuru

select a.*,d.* from dept a
left join emp d on a.deptno=d.deptno where d.deptno is null

Does table partitioning improve performance?

0 Answers  

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

Different Types of Functions ?

2 Answers   Satyam,

Why are sql functions used?

0 Answers  

how to change column into row in sql

4 Answers   ESS,

Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,

How to list all stored procedures in the current database using ms sql server?

0 Answers  

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

What are the purposes and advantages stored procedure?

0 Answers  

Mention the different types of triggers?

0 Answers