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
- 10362 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 you would rewrite the sql query to return the customerid sorted numerically?
Explain how to send email from sql database?
What is coalesce in sql server?
Can truncate be rolled back?
Can you roll back the ddl statement in a trigger?
What are the different authentication modes in sql server? How can it be changed?
Define outer join?
What is awe?
Does windows server 2016 come with sql server?
How to use user defined functions in expressions?
What is sql or structured query language?
What are dml triggers and types of dml triggers?
Why I am getting this error when dropping a database in ms sql server?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is the difference between drop table and truncate table?
