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

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,

what is the syntax for using sql_variant_property? : Transact sql

0 Answers  

how to do backup entire database? : Transact sql

0 Answers  

How many triggers can be implemented for a table?

3 Answers   HSBC,

What is the difference between union and union all command?

0 Answers  

Differentiate pl/sql and sql?

0 Answers  

what is Difference between Having and Where clause?

5 Answers   IBM,

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

Is sql microsoft?

0 Answers  

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

Why we use pl sql?

0 Answers