Answer Posted / surya

select * from emp where &n-1=(select count(distinct sal)
from emp e where emp.sal<e.sal);

For example:-
If you enter n=1,it will display first highest salary
if you enter n=2,it will display second highest salary
......

if you enter n=nth,it will display nth salary

What do you mean by merge in oracle and how can we merge two tables?

1051

---

Explain an index segment?

1124

---

What is ASM (Automatic Storage Management) in Oracle?

1198

---

What is integrity and what is constraint??Explain with example

2286

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

---

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

2355

---

What are the set operators union, union all, minus & intersect meant to do?

989

---

candidate key is subset of super key but not vice-verse explain

2070

---

Can we create database in oracle using command line ?

1091

---

How to execute a stored procedure in oracle?

1093

---

How to convert dates to characters in oracle?

1042

---

Can a formula column be obtained through a select statement ?

2333

---

Can select statements be used on views in oracle?

1029

---

What is the usage of synonyms?

1146

---

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

1098

---