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
- 10539 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 function of inner join?
ow to bring suspect mode datbase online from scratch
Difference between Inner vs outer joins?
What is database black box testing?
How to name query output columns in ms sql server?
What is usually the first word in a sql query?
How to rebuild the master database?
What is a select query statement in ms sql server?
What is a database table?
SQL Server Architecture ?
What are the new data types are introduced in sql 2000?
How to replace given values with null using nullif()?
What is isolation levels?
How can I create a new template for import ? : sql server management studio
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
