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,

---

What is a view and what are its advantages?

0 Answers  

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

0 Answers   HCL,

---

How to delete a database in ms sql server?

0 Answers  

---

---

What is unique key constraint?

0 Answers  

---

What is the maximum rows in sql server table?

0 Answers  

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---

What does this statement do @@rowcount?

0 Answers  

---

Define normalisation?

0 Answers  

---

Does partitioning ssd reduce performance?

0 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---