Answer Posted / brijesh

hi,

this query gives you the Nth highest salary, the trick is to
write (N-1) in the given place;

select salary from table as table1

where (n-1) =

(select count(salary) from table

where table1.salary<salary);

What is the use of file param in imp command?

1165

---

What is difference between cartesian join and cross join?

1088

---

material view and view disadvantages?

1070

---

What is the simplest tool to run commands on oracle servers?

1007

---

What is the usage of synonyms?

1139

---

What are transaction isolation levels supported by oracle?

1070

---

How many types of tables are there in oracle?

1061

---

How to display row numbers with the records?

1075

---

What is SQL access advisor in Oracle?

1186

---

What do you mean by a deadlock?

1061

---

What happens to the current transaction if the session is killed?

986

---

What is procedure overloading in oracle?

1057

---

How can you use check constraints for self referential integrity?

968

---

How to invoke the data pump import utility?

1162

---

What is an oracle cursor variable?

1075

---