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
- 12033 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
How to change the name of a database user?
What is unique key constraint?
What is the full form of dql?
When would you use the stored procedures or functions?
What is difference between rownum and row_number?
What is the most common trace flags used with sql server?
How to check parameter value in stored procedure sql server?
How to find out what is the default collation in a database?
What is sql server profiler?
What is Sqlpaging in SqlServer 2005 ?
How to Insert multiple rows with a single insert statement?
What are the differences between left join and inner join in sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Will count(column) include columns with null values in its count?
What is 5nf in normalization form?
