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
Explain type casting and type juggling.
What does the initials of php stand for?
How to read and display a HTML source from the website url?
Explain what is meant by pear in php?
How do you define a constant?
Is null empty php?
What is the difference between require and include in php?
What is php and sql used for?
What are include() and require() functions?
The left association operator % is used in PHP for?
What is ci in php?
What is the main function of php?
What is the difference between characters 23 and x23?
What exactly is validating and sanitizing?
How do you end php?
