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 are the main sources of data?

0 Answers  

---

Explain how to send email from sql database?

0 Answers  

---

Does partitioning ssd reduce performance?

0 Answers  

---

What are differences in between sql server 2012 and sql server 2016?

0 Answers  

---

What is acid properties?

0 Answers  

---

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

---

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,

---

How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

---

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

---

What is Deadlock?

4 Answers   Satyam,

---