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   Tech Mahindra,

---

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

How do you delete duplicate rows in sql server?

0 Answers  

---

How to modify an existing user defined function?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

What is ddl command?

0 Answers  

---

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

---

what is curser.

9 Answers  

---

What are the differences between stored procedure and view in sql server?

0 Answers  

---

what is a transaction and what are acid properties? : Sql server database administration

0 Answers  

---

what is trigger . hw will it use them

2 Answers   TCS,

---

Explain how to maintain a fill factor in existing indexes?

0 Answers  

---