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 materialized view?

3 Answers  

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

What is BCP? When does it used in sql server 2012?

0 Answers   TryTechnicals Pvt Ltd,

---

How many categories of functions based their return modes?

0 Answers  

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

---

What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

---

Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

How do you know if sql server is running on your local system?

0 Answers  

---