Hey folks -
SQL query please.
I've looked this up on the internet and other forums by example but I can't seem to make it work for my specific requirements. I hope someone can point me in the right direction.
I have a fictional list of bookmakers for a project I'm working on, and odds of an event happening. it has the following columns.
book, home, away, home_odds and away_odds.
There are several books all offering odds on the same event - I want to return the name of the book and the odds for the best odds for home_odds
if you can imagine something like this:
select book, home_odds where home_odds = max(home_odds)
I know this isn't correct but could someone point me in the right direction?
Would this query suffice?
SELECT book, home_odds FROM table ORDER BY home_odds DESC LIMIT 1
Indeed it did - thanks!
Couldn't see the wood for the trees
Well done, sir.