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
- 10796 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
How many servers can we create in a single subscription?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is sql server profiler trace data file?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What happens if you delete a table that is used by a view?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What are a scheduled jobs or what is a scheduled tasks?
What is set nocount on?
What is the security principal at the server level that represents your session?
What are the 10 characteristics of data quality?
What are magic tables in sql server?
What is view in sql?
What is 3nf normalization?
What is an entity-relationship diagram (erd)?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
