Answer Posted / manikandan. s

This is the nth max

SELECT salary
FROM (SELECT ROWNUM sl, salary
FROM (SELECT salary
FROM employees
GROUP BY salary
ORDER BY salary))
WHERE sl = n

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2422

---

How to delete a column in an existing table?

1130

---

What is the minimum client footprint required to connect c# to an oracle database?

1161

---

What is data file?

1150

---

What is Library Cache in Oracle?

1187

---

How view is different from a table?

1082

---

What is a synonym? What are its various types?

1171

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2148

---

How to drop a stored function?

1183

---

How to convert raw data type into text in oracle? Explain

1046

---

What is private procedure oracle?

1049

---

What is the scope of a local variable?

1122

---

What is a nvl function?

1096

---

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

1057

---

Explain the use of online redo log files in oracle.

1078

---