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
- 9117 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
Explain how to maintain a fill factor in existing indexes?
Why do we use non clustered index?
Which sql server is best?
What is ddl and dml commands?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What are a database and a data warehouse?
Can we insert data into view sql server?
What are partitioned views?
What are different types of raid levels?
How to backup encryption key ?
Is mysql better than sql server?
What is difference between primary key and foreign key?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is a database in ms sql server?
Explain the commands in sql server?
