getting max value, without use of max or top

[kayanaat sidiqui]

Hi,

I am having table tab1 there are following column.
col1,col2 and col3
I have to find the output as the row of record cooresponding to highest value of col3.
Don't use max and top function.

Thank you.

[Jeanne Boyarsky]

Why can't you use max? That would be the logically way of doing this. (If it's because it is homework, you aren't likely to get an answer here. If there is a business reason, please share it.)