Answer / shailesh

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

Answer / jitendra

To get nth highest Salary, use below query

SELECT TOP 1 salary
FROM (
SELECT TOP nth salary
FROM Emp
ORDER BY salary DESC
) TmpTable
ORDER BY salary ASC

Replace nth with your number like second highest=2 4th=4 etc

Answer / vivek ghorad

select min(select top(2)salary from emp)from emp;

Can we call dml statement in function?

0 Answers  

---

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

---

What is the difference between a primary key and a unique key?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

How to handle bulk data?

0 Answers  

---

How much does sqlite cost?

0 Answers  

---

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

---

What does rownum mean in sql?

0 Answers  

---

What is denormalization in a database?

0 Answers  

---

What is schema in sql?

0 Answers  

---

What is meaning of <> in sql?

0 Answers  

---

Which is faster count (*) or count 1?

0 Answers  

---