Return entire row where a value = max(value)

Databases
1

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?

Many thanks.
DS

2

Would this query suffice?

SELECT book, home_odds FROM table ORDER BY home_odds DESC LIMIT 1
3

Indeed it did - thanks!
Couldn’t see the wood for the trees :slight_smile:

Well done, sir.

DS