How to select other data columns when using max function?

[ncsthbell]

I am trying to run a query in access using the 'max' function. For example, I have many rows of data, one for each state and each state has a column for 'Miles'. I want to get the highest number of miles so I am using the max function... Select max(miles) from table. It works and returns the largest number in this column. I also need the state that is associated with the max miles so I changed my select to:
Select state, max(miles) from table. However, when I run this select I get an error saying that 'state' is not part of an aggregate function. If I use any aggregate function on 'state', I do not get the correct info. How do I get other data columns from the same row the max function returns???

[Rabbit]

You have to tell it to group by state.

SELECT State, Max(Miles) AS MaxOfMiles
FROM SomeTable
GROUP BY State;
 

[ncsthbell]

This did not give me the results I needed. My data, for example has multiple rows for each of the states. Example:
St Miles
AL 100
AL 200
AL 300
WV 250
WV 350
WV 450
When I put the group by state on the select statement, it returned a row for each state with the max miles for that state so what I got was AL-300 miles, WV-450 miles, and etc. What I need is the max miles over all the rows of data, regardless of the state and whatever row it selects for the max miles, I need to know the state. Does this make sense?

[Rabbit]

SELECT TOP 1 State, Miles
FROM SomeTable
ORDER BY Miles DESC;
 

This will return all records that tie for highest miles though.