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
Is age an interval or ratio?
Do you know what are traits?
Is there an easy way to delete an element from a php array?
What is difference between put and post method in http?
How does php and apache work?
How to access a global variable inside a function?
How to delete a file from the system?
Is python easier than php?
how retrive the video file in php using video tag
How to calculate the length of a string?
What is magic quotes?
What is empty php?
Tell me what is the use of isset() in php?
What are the differences between php constants and variables?
Write a program to get second highest number in an array using php?