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);

How to define a record variable to store a table row?

0 Answers  

---

What are the oracle differences between nvl and coalesce

0 Answers  

---

Why use resource manager in Oracle?

0 Answers   MCN Solutions,

---

how to retrieve 1st and last row of table without using group functions??

6 Answers  

---

What is a trigger oracle?

0 Answers  

---

How to rebuild an index in oracle?

0 Answers  

---

Define the terms primary key foreign key and also the difference between primary and the unique key

2 Answers  

---

How to specify default values in insert statement using oracle?

0 Answers  

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

0 Answers   Oracle,

---

What is proxy method?

0 Answers  

---

Can group functions be used in the order by clause in oracle?

0 Answers  

---

How to create id with auto_increment on oracle?

0 Answers  

---