Answer Posted / tulasi

select * from emp x where 1=(select count(distinct sal)
from emp y where x.sal<=y.sal);

query to find nth sal

select * from emp x where &n=(select count(distinct sal)
from emp y where x.sal<=y.sal);

Why is oracle database so popular?

949

---

How to load data through external tables?

1074

---

What is a table index in oracle?

1071

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2302

---

What is rich query?

929

---

What is dual table oracle?

927

---

What is flashback in Oracle?

967

---

What is raw datatype?

1081

---

How to start your 10g xe server from command line?

1001

---

What is format trigger?

2016

---

how do u setup a replication site?

1925

---

What are joins, explain all types of joins?

2221

---

How to create a new tablespace in oracle?

934

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2130

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1010

---