How to get the second highest from a Table

Its my pleasure.

hi bro. This query return max value means 1st one value in resultset. To return 2nd value use min(salary) instead of max(salary). thanks for post.

You probably need to discuss this in more details. What your table design is and what the field types etc.