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
- 9959 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
Explain trigger and its types?
What is raiseerror? What is raiseerror?
What are the operating modes in which database mirroring runs?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Define outer join?
How do you know if sql server is running on your local system?
Which are the third-party tools used in sql server and why would you use them?
What is model database? : SQL Server Architecture
Explain aggregate functions?
How to use subqueries with the in operators in ms sql server?
What is tabulation?
Is mysql the same as sql server?
What is blocking?
What is the difference between varchar and varchar types?
Write a SQL queries on Self Join and Inner Join.
