Answer Posted / janmejaya

select top(1) * from employee where salary in (select
distinct top(2) salary from employee order by salary desc)
order by Salary




Above query is dynamic, if u want 3rd highest then just
change 2 to 3 , Please Try It

What is open database communication (odbc) in oracle?

1003

---

Is truncate autocommit in oracle?

1087

---

What privilege is needed for a user to query tables in another schema?

973

---

How to create a new oracle data file?

1032

---

What are the different oracle database objects?

1092

---

How to delete all rows a table in oracle?

1068

---

How to use select statement to count the number of rows in oracle?

1046

---

What are the attributes that are found in a cursor?

1078

---

How many types of synonyms in Oracle?

1124

---

How to retrieve data from an cursor to a record?

1104

---

What are the varoius components of physical database structure of oracle database?

1006

---

What is oracle and what are its different editions?

1066

---

What is raw datatype?

1136

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1046

---

What are the roles of dba?

1069

---