Answer Posted / sunil

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)
as rnk from table_name) where rnk=2;

How to assign a table row to a record variable?

1048

---

How do we get field details of a table?

983

---

Is primary key indexed by default in oracle?

994

---

Use of an integrity constraint is better to validate data. Explain

1046

---

How to create a table in a specific tablespace?

982

---

How can I create database in oracle?

1032

---

what is the difference between restoring and recovering?

1018

---

What is the difference between sharding and partitioning?

994

---

How to shutdown your 10g xe server from command line?

1095

---

What are the differences between interval year to month and interval day to second?

1032

---

What does sharding mean?

1010

---

What exactly do quotation marks around the table name do?

968

---

How to pass a parameter to a cursor in oracle?

1192

---

What are the different editions of oracle?

1115

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2271

---