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;

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2153

---

How to pass parameters to procedures in oracle?

1047

---

Design database draw er diagram for a certain scenario ?

4584

---

What is query image?

985

---

Explain oracle insert into command?

1117

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2187

---

How to use "in out" parameter properly?

1055

---

can u plz provide me oca sql dumps please i need them

1957

---

What is oracle and what are its different editions?

1073

---

How to create a new table by selecting rows from another table?

1107

---

What is difference between truncate and delete?

1048

---

What are the different types of partitions in oracle?

982

---

What is procedure overloading in oracle?

1066

---

What is an oracle tablespace?

1051

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2283

---