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
- 8663 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 is the difference between online clustering and Offline clustering?
What is the simplest way to create a new database in ms sql server?
Explain DBCC?
How to apply filtering criteria at group level with the having clause in ms sql server?
Explain trigger and its types?
Explain what are the authentication modes in sql server?
What is Service Broker in sql server 2012?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What are system databases in ms sql server?
Which command is used for user defined error messages?
Describe the left outer join & right outer join. : sql server database administration
Can we store videos inside the sql server table?
Are all views updatable ?
What is the process of indexing?
What are the essential components of sql server service broker?
