1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

---

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 to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---

What is the main purpose of having conversation group?

0 Answers  

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  

---

What’s the use of custom fields in report?

0 Answers  

---

how to connect sybase to sql server 2005?.

1 Answers   ABC,

---

What is a database table?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

---