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
- 8693 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
Define synonym?
What is the difference between Clustered and Non-Clustered Index?
Explain differentiate between a having clause and a where clause?
In what sequence sql statement is processed?
What is sqlcmd?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
How is sql server used?
What is the use of =,==,=== operators?
What is a dataset and what are the different types of datasets?
Why we need sql server?
What is rank function?
How to enter binary string literals in ms sql server?
Explain trigger and trigger types?
Does sql server 2000 clustering support load balancing?
List some advantages and disadvantages of stored procedure?
