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
- 10844 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ayush
create proc DeptName
begin
select * from emp full join dept on emp.deptno=dept.deptno
where empno is null;
end
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of using a stored procedure?
Do you know what are the ways available in sql server to execute sql statements?
How to make conditional sum in ssrs?
what is the sql equivaent of the dataset relation object ?
Is candidate a key?
What are relationships and mention different types of relationships in the dbms
How you provide security to cube? : sql server analysis services, ssas
List down some advantages of sql stored procedure?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
your distribution database is full what will u do
When a primary key constraint is included in a table, what other constraints does this imply?
How can you hide the sql server instances?
What is entity data services?
What is an identity?
How to fine-tune reports?
