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 a data source or ds? : sql server analysis services, ssas

0 Answers  

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

0 Answers  

---

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

0 Answers  

---

Explain how to use linked server?

0 Answers  

---

What are sparse columns?

0 Answers  

---

How to display a past time in days, hours and minutes?

0 Answers  

---

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  

---

Can a table be moved to different filegroup?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

What is optimization and its types?

0 Answers  

---

When is the use of update_statistics command?

0 Answers  

---