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 sid in oracle?

972

---

How to define an anonymous procedure without variables?

1111

---

How to rename an existing table?

1129

---

Is there an oracle sql query that aggregates multiple rows into one row?

987

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1079

---

How to execute a stored program unit?

1083

---

Explain the use of file option in exp command.

1134

---

What is an external table?

1027

---

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1865

---

How can I introduce multiple conditions in like operator?

991

---

Which is better Oracle or MS SQL? Why?

6395

---

Explain the use of consistent option in exp command.

1074

---

How to convert character types to numeric types?

1139

---

How remove data files before opening a database?

1078

---

What is a cursor in oracle?

1181

---