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
- 12031 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
Explain full-text query in sql server?
Why would you use sql agent?
Explain the collation?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is difference between index seek vs. Index scan?
What is extent? Types of extents?
Explain the dbcc pintable command when would you use it?
How can we improve performance by using SQL Server profiler?
Which language is supported by sql server?
What is Command line parameters in PLSQL.?
Can you explain what are commit and rollback in sql?
What is model database? : SQL Server Architecture
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is the maximum length of an alert name?
What is RMS migrations?
