Select values based on one max value in SQL?

I am trying to select 3 values from a table in SQL where one of the values is the highest or Max. How would I do this?

I can't write this:

Select Name, ID, Bonus

From Sales.SalesPerson

Where MAX(Bonus)

This gives me an error message. Any ideas?

1 Answer

Relevance
  • 9 years ago
    Favorite Answer

    Select Name, ID, Bonus

    From Sales.SalesPerson

    Where binus = (select MAX(Bonus) From Sales.SalesPerson)

Still have questions? Get your answers by asking now.