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
- 11824 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
How many databases Microsoft SQL server provides?
What is acid properties?
What is the difference between char and varchar2 datatype in sql?
What is the name of reporting services config file and what’s it’s used for?
What is the server name in sql server?
What is implicit mode in sql server?
Explain what is the difference between union and union all?
What is subreport?
Do you know what is similarity and difference between truncate and delete in sql?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What stored by the msdb? : sql server database administration
What is primary key, unique key, and foreign key?
What are “phantom rows”?
What is the purpose of indexing?
Explain “not null constraint” in sql server?
