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
- 10846 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sivaram pothuru
select a.*,d.* from dept a
left join emp d on a.deptno=d.deptno where d.deptno is null
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What are different types of statements that are supported by sql?
can SSRS reports Cache results?
What is difference between rownum and row_number?
What is cdc in sql server?
What is the syntax to execute the sys.dm_db_missing_index_details?
what method you can use to reduce the overhead of Reporting Services data sources?
How to invoke a trigger on demand?
what are the different stages of Report Processing?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is the difference between varchar and nvarchar datatypes?
What is Sqlpaging in SqlServer 2005 ?
what authentication modes does sql server support? : Sql server database administration
What is the default port for SQL Server over a firewall?
what is the difference between openrowset and openquery?
Explain trigger classes i.e. Instead of and after trigger?
