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 difference between for auto and for nested?

0 Answers  

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

---

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

0 Answers  

---

Explain differentiate between a having clause and a where clause?

0 Answers  

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

Differentiate between sql temp table vs table variable?

0 Answers  

---

How to connect a database with sql express.?

0 Answers   MCN Solutions,

---

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  

---

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

---