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,

---

What is the usage of the sign function?

0 Answers  

---

What is a join in sql? What are the types of joins?

0 Answers  

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

Is there any difference between the primary key and unique key?

0 Answers  

---

---

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

---

Explain transaction server consistency?

0 Answers  

---

When should you use an instead of trigger?

0 Answers  

---

What is a subquery in a select query statement in ms sql server?

0 Answers  

---

What do you mean by acid?

0 Answers  

---

How do you find the number of rows in a table?

7 Answers  

---

What is data modification?

0 Answers  

---