Interested to Buy Any Domain ? << Click Here >> for more details...
How to find second highest salary
- 9 Answers
- 12974 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 |
What is the use of isset() in php?
how can i upload only pdf files in my website? files has not a pdf extension mantioned
What are the four scalar types of php?
How do I escape data before storing it in the database?
how can i get USA time using php...
What is the difference between single-quoted and double-quoted strings in php?
Can php run without apache?
Which PHP function would you use to send an email?
which institute provide better PHP trainning in delhi? please tell me how much salary can freshers get ? thanku
What does namespace mean in php?
What are include() and require() functions?
What are the functions of string?
PHP 
