Answer Posted / abhijit

select max(sal) from table_name where
sal<(select max(sal) from table_name);

or

select sal from(select sal,dense_rank() over(order by sal
desc)
as rnk from table_name) where rnk=2;

what is the dual table in oracle?

993

---

How to write date and time interval literals in oracle?

1036

---

Explain mutating triggers.

1031

---

How to delete an existing row from a table in oracle?

1072

---

How to create tables for odbc connection testing?

1117

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3902

---

What is logical backup in oracle?

1018

---

Explain the difference between sql and oracle?

1079

---

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

989

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1995

---

What is different types of joins?

1022

---

How to create a temporary table in oracle?

1270

---

What is an anonymous block?

1254

---

what is the use of system.effective.date variable in oracle?

1116

---

how to make an oracle object

2359

---