Having problem with MAX function

I am having a little problem here with MAX function and would be very nice if anyone could guide me through this.


I have the table called sale1. I have several columns but I dont want to confuse you with all of them. Lets just say I have the following two columns with the two records::

sale_id number
SL0001 1
SL0002 2

Now to display the the maximum number we do the following:

select max(number) from sale1
Output: 2

How could I display the sale_id next to it?
Expected Output: SL0002 2


I tried lots of ways before posting this message. I did subquery as well.

select sale_id, number
from sale1
where number in (select max(number) from sale1);

The server gave me error. I dont know what the error i.......If anyone could give me some instructions it will be very nice.

If all you want is the highest number, just do this:

Thank you very much. That is all i wanted and it worked perfectly.