Interested to Buy Any Domain ? << Click Here >> for more details...
How to find second highest salary
- 9 Answers
- 12728 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / shrikant patil
select max(salary) from tbl_name where salary !=(select
max(salary) from tbl_name);
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / devasundaram
SELECT salary FROM Employee_table ORDER BY salary DESC LIMIT 1,1
| Is This Answer Correct ? | 13 Yes | 10 No |
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);
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / petercoloney
select salary from employee where max(salary)<(select salary from employee)
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / jose_100
SELECT SAL FROM SALARY_TABLE ORDER BY SAL DESC LIMIT 1,1;
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vishnu
select salary from table where salary!=max(salary) order by
desc limit 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nitish
SELECT sallary FROM employee ORDER BY sallary ASC limit 1,2
| Is This Answer Correct ? | 16 Yes | 22 No |
Answer / jaimin desai
Select MAX(Salary) from tbl
order by salary DESC limit 1,1
| Is This Answer Correct ? | 1 Yes | 7 No |
Which function will suitably replace 'x' if the size of a file needs to be checked? $Size=x(filename);
Tell me what are the encryption techniques in php?
How do I find out the number of parameters passed into function9?
What is the use of friend function in php?
Is server side a session?
How to set a page as a home page in a php based site?
How can we convert the time zones using PHP?
Can we use session in mvc?
What is static variable in php?
How can we set and destroy the cookie in php?
What is a procedure in php?
How can we get second of the current time using date function?
PHP 
