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 different types of sql server replication? : sql server replication

0 Answers  

---

When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  

---

What is exclusive locks?

0 Answers  

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

What is the use of =,==,=== operators?

0 Answers  

---

difference between Clustered index and non clustered index ?

0 Answers   Infosys,

---

Explain the difference between control flow and data flow?

0 Answers  

---

What is 2nf example?

0 Answers  

---

Is the log file is a part of file group?

0 Answers  

---

can any one please send sql quries most used in applications.

2 Answers  

---

How many columns can exist together per table?

0 Answers   Cap Gemini,

---