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

13. Display the second to fifth characters in each client name.

2 Answers   Wipro,

---

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 Answers  

---

How to execute a stored program unit?

0 Answers  

---

How to check the server version in oracle?

0 Answers  

---

What is transaction control statement and how many types of transaction control statement in Oracle?

0 Answers   MCN Solutions,

---

What is an oracle recycle bin?

0 Answers  

---

Is oracle an open source?

0 Answers  

---

How to view existing locks on the database?

0 Answers  

---

What are the tools for Oracle ?

0 Answers   Infosys,

---

What happens if variable names collide with table/column names?

0 Answers  

---

Do View contain Data ?

10 Answers  

---

What are nested tables?

0 Answers  

---