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,

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

Explain trigger and trigger types?

0 Answers  

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

What you can do to delete a table without the delete trigger firing?

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

What is a scheduled job or what is a scheduled task?

0 Answers  

---

Do you know data definition language, data control language and data manipulation language?

0 Answers  

---

What is the stored procedure?

0 Answers  

---

what is database replication? : Sql server database administration

0 Answers  

---