Answer Posted / harmeet

Hi, this query will gives the third highest salary from table

select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);

To dispay 5th highest salary, just change the number 3 to 5.
Like that we can find top N salaries.

I hope i'm not wrong.

What is control file used for?

1098

---

Difference between the “verify” and “feedback” command?

1308

---

How to connect to oracle using service name instead of sid?

963

---

What is ADDM Advisor in Oracle?

1115

---

What is oracle host variable?

981

---

Explain an extent?

1048

---

Can multiple columns be used in group by in oracle?

926

---

What is bulk collect in oracle?

954

---

What is an Oracle index?

1602

---

Write a trigger example in oracle?

980

---

State all possible different index configurations a table can possibly have?

947

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2307

---

Explain the difference between sap and oracle?

974

---

List the parts of a database trigger.

988

---

How to write an inner join with the where clause in oracle?

994

---