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);

How to list all tables in your schema?

1001

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2669

---

What happens if you set the sga too low in oracle?

1074

---

What is the maximum limit on the number of columns in a table?

1030

---

Explain an integrity constrains?

1095

---

What is an anonymous block?

1178

---

What is oracle rownum?

897

---

Is there a combination of "like" and "in" in sql?

1017

---

How to write numeric literals in oracle?

1138

---

What are the parameters that we can pass through a stored procedure?

1008

---

What are the differences between date and timestamp in oracle?

997

---

How to list all indexes in your schema?

1048

---

Is insert autocommit in oracle?

1031

---

How index is implemented in oracle database?

964

---

Can we convert a date to char in oracle and if so, what would be the syntax?

974

---