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
- 12311 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
In which format does an image save in SQL Server database ?
What is normalization of database?
Why and when do stored procedure recompile?
What is page in sql server?
Explain active/passive and active/active cluster configurations?
How to create a dynamic cursor with the dynamic option?
How do I get to sql server configuration manager?
What number sorts of privileges are accessible in sql?
How to get the query of a table in sql server?
What are the various editions of sql server 2017 that are available in the market?
Explain the use of containers in ssis?
How to count rows with the count(*) function in ms sql server?
Do you know how to make remote connection in database?
What do we need queues in sql service broker?
Explain atomicity?
