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

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

960

---

How to convert dates to characters in oracle?

987

---

How to start a specific oracle instance?

991

---

Can we write insert statement in function in oracle?

1027

---

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

939

---

What is parameterized cursor in oracle?

1067

---

How do I connect to oracle?

977

---

What do you mean by group by clause?

978

---

What are the built-in functions used for sending Parameters to forms ?

3309

---

What is clustered table in Oracle?

1108

---

How to rename a column in an existing table?

973

---

Differentiate between pre-select and pre-query?

1055

---

Explain what are the advantages of views?

1014

---

What are the execution control statements?

1018

---

Explain the dml?

921

---