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
- 10789 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 many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Why should one not prefix user stored procedures with ‘sp_’?
Please explain go command in sql server?
explain extended properties
How can I create a new template for import ? : sql server management studio
Detail about query optimizer?
What is the sql case statement used for? Explain with an example?
Why are you getting errors when creating a new odbc dsn?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
How can you start sql server in different modes?
What are the advantages of using stored procedures?
Tell me what do we need queues in sql service broker?
Explain the difference between delete,drop and truncate in SQL Server?
What is table value parameters (tvp)?
Where do you find the default Index fill factor and how to change it?
