Hello am trying to get the whole record information based on a max value for example lets say that i have this table called animals
id name price
____ ______ _______
1 dog 250
2 cat 100
3 bird 50
the max price is 250 then I want to retrieve its record so I should get
id name price
____ ____ _____
1 dog 250
here is the query that I wrote but I know its wrong
Select * FROM animals where price = MAX(price);
