Answer / sudha

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

Answer / pranav damele

All the above one works with Oracle; this one is for MYSQL

second highest :
mysql> select * from employee group by salary desc limit 1,1;

limit 1,1; first '1' means that bring cursor to the end of record and the next '1' means number of records to be printed after the cursor position.

third highest:
mysql> select * from employee group by salary desc limit 2,1;

limit 2,1; '2' means that bring cursor to the end of 2nd record and the next '1' means number of records to be printed after the cursor position.

Answer / mohamed hussain

select salary from
(select salary,Dense_RANK() over (Order by salary desc) as
Level from salary) TMP
where Level=@Level

Answer / esakki

select max(salary) from employee where salary not in (select
top 1 salary from employee order by salary desc )


change 1 to 2,3,4,......like that for 3rd max ,4th max
salary.....

Answer / prashanth

select max(sal) from employee where sal<(select max(sal)
from employee)

Answer / ashwini

select top 1 salary from emp where salary in (select top 2
salary from emp order by salary asc) order by salary desc

Answer / naveen r kumar

SELECT Max(salary) FROM TABLE
WHERE salary NOT IN (SELECT Max(salary) FROM TABLE);

Answer / jhansi

select max(sal) from emp where sal<any(select max(sal) from
emp)

Answer / sankar

select * from emp where sal=(select max(sal) from emp where
sal not in(select max(sal) from emp))

Answer / pramila

not only seceond highest . you can retrieve 2nd , 3rd.....
highest salary form this query

select min(Salary) from
(select distinct top 2 Salary from tblCategory order by
Salary desc) as tblCategory

what is offset-fetch filter in tsql? : Transact sql

0 Answers  

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

What does (+) mean in sql joins?

0 Answers  

What is an exception in pl/sql?

0 Answers  

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

What is difference between ms sql and mysql?

0 Answers  

Is oracel sql developer written in java?

0 Answers  

Why partition by is used in sql?

0 Answers  

Explain the PL/SQL compilation process.

3 Answers  

Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,

How do I install sql?

0 Answers  

Where is sql database stored?

0 Answers