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
How can we destroy the cookie in php?
What is session in PHP. How to remove data from a session?
How to send a cookie to the browser?
how to track no of users logged in?
What is self in php?
What is the difference between print() and echo()?
What is php constructor?
How to check a key exist in an array?
What is the importance of php?
What is mean by an associative array?
What is a controller php?
Why do we use in php?
How do you end php?
How to invoke a user function?
sort term descripttion form, report and uery