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
- 9617 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / litmus rav
If there is many to many relationship between two tables
then this will work,
you need to create thired table name A_B with attributes
eid references A(eid),sid references B(sid)
SELECT * FROM A,B,A_B WHERE A.eid=A_B.eid AND B.sid=A_B.sid
AND ORDER BY ename;
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
What are the properties of the relational tables?
What is a heap?
How fixed length strings are truncated and padded?
What is the difference between Clustered and Non-Clustered Index?
What are the two authentication modes in sql server?
What is transaction server consistency?
How do database indexes work?
how many clustered indexes can be created on a table? : Sql server database administration
Differentiate between mongodb vs. Sql server?
How does the report manager work in SSRS?
How to find tables without indexes?
What is 1nf 2nf?
If no size is defined while creating the database, what size will the database have?
Define candidate key, alternate key, and composite key.
Is null vs coalesce?
