Rownum function with order by statement

Hi,
can anybody help me ?

I want to :
select rownum, a
from sometable
order by a

where a :

5
3
6
2

The result I expected is :
1 2
2 3
3 5
4 6

Thanks in advance.... Received on Sun Sep 12 1999 - 19:29:19 CDT