Answer / anuj

For Second Highest Salary:
select salary from tbl_name order by salary desc limit 1,1
For Third Highest Salary:
select salary from tbl_name order by salary desc limit 2,1
For Fourth Highest Salary:
select salary from tbl_name order by salary desc limit 3,1

Answer / shrikant patil

select max(salary) from tbl_name where salary !=(select
max(salary) from tbl_name);

Answer / devasundaram

SELECT salary FROM Employee_table ORDER BY salary DESC LIMIT 1,1

Answer / prakash.matte

if we want to make use of nested query instead of the above,
try the following

select max(column_name) from table_name where column_name =
(select
max(column_name)-(highest_salary_number_for_calculation -1)
from blocks where bid);

Example :

For second highest salary:

select max(bid) from blocks where bid = (select max(bid)-1
from blocks);

For third highest salary:

select max(bid) from blocks where bid = (select max(bid)-2
from blocks);

Answer / petercoloney

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

Answer / jose_100

SELECT SAL FROM SALARY_TABLE ORDER BY SAL DESC LIMIT 1,1;

Answer / vishnu

select salary from table where salary!=max(salary) order by
desc limit 1

Answer / nitish

SELECT sallary FROM employee ORDER BY sallary ASC limit 1,2

Answer / jaimin desai

Select MAX(Salary) from tbl
order by salary DESC limit 1,1

Is null function in php?

0 Answers  

Extract url from this string? It should be flexible for all strings, not for this string only. "yahoo.comyahoo.co.inhotmail.org"

1 Answers   A1 Technology,

What is faster?

0 Answers  

Explain me the difference between include and require?

0 Answers  

Explain Type juggling?

0 Answers  

What is foreach loop in php?

0 Answers  

Is multilevel inheritance possible in php?

0 Answers  

Draw the architecture of Zend engine?

4 Answers  

What is meant by ‘passing the variable by value and reference' in php?

0 Answers  

What is a persistent cookie in php?

0 Answers  

What is laracast?

0 Answers  

How to set a value in session? How to remove data from a session?

0 Answers