Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10609 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
What does it mean if @@cursor_row returns a negative number?
What is the purpose of sql profiler in sql server? : sql server database administration
How to connect Azure federated root database and apply federation in entity framework?
What is change tracking in sql server?
What is built-in function?
How to update values in a table with update statements in ms sql server?
What is the difference between varchar and nvarchar?
Explain what role entity and relationship play in an ER diagram.
Do you know nested transaction?
What command do we use to rename a database?
What are the database roles? : sql server security
Call by value and call by reference in procedure and function, with NOCOPY.
What is the log shipping?
Difference between LEN() and DATALENGTH() in sql server ?
What are basics of policy management?
