Interested to Buy Any Domain ? << Click Here >> for more details...
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 does csrf token work?
Why should I store logs in a database rather than a file?
"mysql_fetch_row — Get a result row as an enumerated array",this sentence comes from the PHP offical manual.However ,i can not understand the words "enumerated array".I need some help.Thanks a lot to everyone that reply.
What is the best website to learn php?
Tell us what is the difference between session_unregister() and session_unset()?
How long will it take to learn php?
How do you define a constant?
How do I run a php script?
What does the array operator '===' means?
How cookies are transported from servers to browsers?
Explain about PHP cookies?
What good is polymorphism?
Explain the difference between require() and require_once()?
Which of the data type is compound datatype supported by PHP?
Explain PHP looping?
