Answer Posted / 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 |
Post New Answer View All Answers
What are the differences between require and include?
What is a php certification?
What is the importance of "action" attribute in a html form?
Name some of the constants in php and their purpose.
how to track no of users logged in?
What is a php web application?
What is $_ request?
What exactly is validating and sanitizing?
How is it possible to cast types in php?
What is the difference between get & post ?
What is the output of the following php code?
How to count a number of words in a string in php?
Explain me is it possible to destroy a cookie?
Is php coding easy?
What is the correct and the most two common way to start and finish a php block of code?