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
- 9118 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
What are commit and rollback in sql?
What is difference between materialized view and view?
How do I create a stored procedure in dbml?
How to use column default values in insert statements in ms sql server?
Can group functions be mixed with non-group selection fields in ms sql server?
What is the difference between set and select?
What are Row versions of DataRow?
Explain the difference between control flow and data flow?
What is the difference between delete and truncate statements?
How to create a new schema in a database?
What is left outer join in sql server joins?
What do you understand by mirroring?
Can binary strings be used in arithmetical operations?
Define a cross join?
What are the advantages of paper records?
