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;

Is id a reserved word in sql?

0 Answers  

---

What is data abstraction in sql?

0 Answers  

---

What are the types of join in sql?

0 Answers  

---

Types of joins?

4 Answers   Microsoft,

---

What are the different sql languages?

0 Answers  

---

What is the difference between explicit and implicit cursors in oracle?

0 Answers  

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

0 Answers  

---

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 Answers  

---

Is it possible to update views?

0 Answers  

---

How to start the command-line sql*plus?

0 Answers  

---

Explain commit, rollback and savepoint.

0 Answers  

---

what is hash join

1 Answers   NCR,

---