Answer / lakshmi

select sal from emp
where sal = (max(sal) from emp
where sal < (max(sal) from emp
where sal < (max(sal) from emp)));

Answer / ashutosh pandey

select sal from emp
where sal=(select min(sal) from emp
where sal>(select min(sal) from emp
where sal>(select min(sal) from emp);

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

0 Answers  

---

What is Water Mark in Oracle?

7 Answers   Oracle,

---

12. Display the client name in upper case only and in lower case only.

1 Answers   Wipro,

---

What is a data lock in oracle?

0 Answers  

---

How do I uninstall oracle client from windows?

0 Answers  

---

---

What are the different editions of oracle?

0 Answers  

---

How to rebuild an index in oracle?

0 Answers  

---

What is the difference between a user and a schema in oracle?

0 Answers  

---

What is a OUTER JOIN?

1 Answers  

---

How to drop a tablespace?

0 Answers  

---

how to find out largest value in a table

2 Answers  

---

How many types of tables supported by oracle?

0 Answers  

---