[eluser]Bigil Michael[/eluser]
can u help me???
iam in a majour problem,no one responding
i want to find out the second maximum value
Quote:SELECT * FROM candidate_details WHERE candidate_votes=(SELECT max(candidate_votes) FROM candidate_details WHERE candidate_votes< (SELECT max(candidate_votes) FROM candidate_details))
this code is running smoothly
when i added extra condition it is not working
Quote:SELECT * FROM candidate_details WHERE candidate_votes=(SELECT max(candidate_votes) FROM candidate_details WHERE candidate_votes< (SELECT max(candidate_votes) FROM candidate_details)) AND elect_year = '2010'
can u help me?
please....