select a.*,d.* from dept a left join emp d on a.deptno=d.deptno where d.d

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

Question Posted / sivaram pothuru

7 Answers
12032 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

Please Help Members By Posting Answers For Below Questions

How column data types are determined in a view?

947

What are the hotfixes and patches in sql server?

1006

Where the sql logs gets stored? : sql server database administration

947

How to list all schemas in a database?

1043

What is the importance of concurrency control?

1212

how you can list all the tables in a database?

1015

What are the various editions of sql server 2017 that are available in the market?

882

What is instead of dml trigger?

980

How to list all user defined functions in the current database?

1024

What is the use of keyword with encryption. Create a store procedure with encryption?

947

Do you know spatial data types - geometry and geography in sql server 2008?

1009

How to Sync Two SQL Azure Databases?

119

What are null values in ms sql server?

1063

How to find the login name linked to a given user name?

997

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1033