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 an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

---

How to download microsoft sql server 2005 express edition?

0 Answers  

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

---

What is the architecture of ms sql reporting service?

0 Answers  

---

Does sql server 2000 clustering support load balancing?

0 Answers  

---

Explain the relational database management system (rdbms)?

0 Answers  

---

Is oracle faster than sql server?

0 Answers  

---

What is a primary key?

0 Answers  

---

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

---

What is analysis service repository?

0 Answers  

---

How to see existing views in ms sql server?

0 Answers  

---