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 Raise_application_error ?

1 Answers  

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

0 Answers  

what is the difference between $message and $$message? : Sql dba

0 Answers  

What are some emotional triggers?

0 Answers  

Can a composite key be null?

0 Answers  

Is sql microsoft?

0 Answers  

How to select 10 records from a table?

0 Answers  

Explain lock escalation? : Transact sql

0 Answers  

What is pessimistic concurrency control? : Transact sql

0 Answers  

Which is the best place to learn hadoop?

1 Answers  

How do I find sql profiler?

0 Answers  

How many triggers can be implemented for a table?

3 Answers   HSBC,