Answer Posted / husenaiah.b

select empno,ename,sal from
(select empno,ename,sal from emp order by sal desc)
group by rownum,ename,sal having rownum=&n;
from this query we can find top nth sal

How can I get column names from a table in oracle?

1055

---

How to write a query with an inner join in oracle?

1048

---

How to set up autotrace for a user account?

1062

---

How do I limit the number of rows returned by an oracle query after ordering?

1176

---

How to use "if" statements on multiple conditions?

1179

---

What is bulk copy or bcp in oracle?

1130

---

Explain the use of tables option in exp command.

1123

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2331

---

How to use "in" parameter properly?

1078

---

Explain cascading triggers.

1082

---

What is oracle rowcount?

1090

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4526

---

Explain parameter file in oracle.

1036

---

How many categories of data types in oracle?

1036

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

985

---