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
- 10440 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / jayesh sonawane
this one correct try it:
SELECT
distinct
B.NAMES AS NAMES
B.SID
,B.DEPT AS DEPARTMENT
,B.SALARY AS SALARY
,B.DESIGNATION AS DESIGNATION
FROM TABLEB AS A join TABLEB AS b
on A.EID=B.SID and B.DEPT=A.DEPT and B.SALARY=A.SALARY and B.DESIGNATION =A.DESIGNATION
join TABLEA as taba on ON A.taba =B.SID
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to loop through returning rows?
Explain try...catch with sql server?
How to convert a unicode strings to non-unicode strings?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
How can you insert null values in a column while inserting the data?
Define constraints and give an example of their use?
When a primary key constraint is included in a table, what other constraints does this imply?
Where are full-text indexes stored?
What is sql server schema compare? How we can compare two database schemas?
What are a database and a data warehouse?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What are the advantages of sql azure?
What are a scheduled jobs?
What is the data type of time?
When should you use an instead of trigger?
