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
- 10808 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
How we can refresh the view?
What is a View ? Can we insert, Update and delete a view?
How do I know if localdb is running?
What is the difference between writing data to mirrored drives versus raid5 drives
What is the difference between for xml raw and for xml auto?
What are the drawbacks of reporting in ssrs?
Difference between group by clause and having clause in SQL?
What is snapshot replication?
What is the difference between join and inner join?
Can binary strings be converted into numeric or float data types?
What is the function of sql server agent windows service?
How do I determine how many instances of sql server are installed on a computer?
What is service broker?
How much does sql server 2016 cost?
what are defaults? : Sql server database administration
