Hi

Query below can be a answer for your question !

Select max(name), sal from emp
group by sal
order by sal desc

I don't know how significant 'name' is going
to be in the output, but use max(), min()
function with name accordingly, if it is
just a matter of finding largest or smallest alphabet?!!

Cheers,
Nandu