problem in finding second maximum value

[eluser]John_Betong_002[/eluser]
Can you try this:

Code:

SELECT *
FROM     candidate_details
ORDER BY candidate_votes
DESC
LIMIT    0,5

 
If that gives consistent satisfactory results then write some code to select the values from the result.