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?