I have two columns A and B. I want to select the value of column A where B has its maximum value.

```
SELECT MAX(B) FROM table_name

```

just gives me the value of B.

I can do another query with the value of B to get A, but is there a shorter way with just one SQL query?