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
- 10602 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
Indexes are updated automatically is the full-text index also updated automatically?
What is triggers in ms sql server?
Can two tables share a primary key?
How to display a past time in days, hours and minutes?
What is the difference between resultset and resultsetmetadata?
What is self contained scalar sub query?
What is an indice?
What is indexing in sql server with example?
What is transact-sql language?
What do you understand by replication in sql server?
How to rebuild all indexes on a single table?
What is extent? Types of extents?
Explain where clause?
How to transfer a table from one schema to another?
What is transaction server implicit?
