I have a table where age field is there.I want to fetch the second highest age from the table.
Try this !
SELECT party, income FROM party_income WHERE income = (SELECT MAX(income) FROM party_income WHERE income < (SELECT MAX(income) FROM party_income))
Username
Password
Remember Me
Lost your password?
Username or E-mail:
Log in