Hey guys, im in need of some help.
My Table columsn atm are.
Basically I have a sub table which holds an auction listing. Then I have a bid table to record all subsequent bids on those items. Items linked to the auction have the same listing_id number as the listing. The bid_id is just a unique number for each bid irrelevant of which listing they are linked to, and the value is the monetry value they are bidding.
My query atm currently is:
select max(bid_value) from trp_bids where listing_id='4'
I know this works, as it returns the appropriate value. What I would like to do is return not the highest value in the table, but the second highest. Anyhelp would be much appreciated.