how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

what are the advanced features in sql 2008?

2 Answers   Wipro,

---

Do you know the cursor types?

0 Answers  

---

How to delete all rows with truncate table statement in ms sql server?

0 Answers  

---

what are cursors? : Sql server database administration

0 Answers  

---

What is difference between join and natural join?

0 Answers  

---

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,

---

How do you trace the traffic hitting a sql server?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

---

What is always encrypted?

0 Answers  

---