Answer / Kavita Saini

To display employee records who get more salary than the average salary in a department, you can use SQL subqueries and analytic functions. Here's an example using Oracle SQL:nn```sqlnSELECT * FROM employeesnWHERE salary > (SELECT AVG(salary) FROM employees WHERE department_id = employees.department_id);n```

when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 Answers  

---

What is a View ?

3 Answers  

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1 Answers  

---

What privilege is needed for a user to insert rows to tables in another schema?

1 Answers  

---

Explain the truncate in oracle?

1 Answers  

---

various types of hints and their usage

1 Answers  

---

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers   Bravura Solutions, Cap Gemini,

---

What is bind variable in oracle 11g?

1 Answers  

---

candidate key is subset of super key but not vice-verse explain

1 Answers  

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help

5 Answers  

---

How to get a list of all user accounts in the database?

1 Answers  

---