Their are two tables 'A' and'B'.Table 'A' contains 3 columns
named 'eid','ename','dept'.
Table 'B'contains 3 columns
named'sid','designation','salary'.
We have to retrieve the names of employees working in the
same department,same designation and same salary.
Its urgent can anyone help me out in this problem.
- 6 Answers
- 8694 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / jeya
select Emp.* , sal.*
From Emp
Inner Join Sal On Emp.EmpId = sal.EmpId
Inner Join (
Select X.Department , sal.Designation , sal.salary
From Emp
Inner join (
Select Department
From emp Group By Department Having COUNT(*) > 1
)As X On X.Department = Emp.Department
Inner Join Sal On sal.EmpId = emp.EmpId
Group by X.Department , sal.Designation , sal.salary
Having COUNT(*) > 1
)as y on y.Department = emp.Department and y.Designation =
sal.Designation
and y.salary = Sal.salary
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
List down some advantages of sql stored procedure?
What is cube dimension? : sql server analysis services, ssas
Mention the different types of triggers?
Difference between Logical Page and Physical Page in SSRS.
what is the sql equivaent of the dataset relation object ?
How to insert and update data into a table with "insert" and "update" statements?
What is dbcc?
Explain what is public role in sql server?
What is scalar user-defined function?
What is normalization of database? What are its benefits?
define and explain the differences between clustered and non-clustered indexes.
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
How many types of functions are there in sql server?
Explain stored procedure?
What is efficiency data?
