Re: Rownum function with order by statement

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Mon, 13 Sep 1999 01:35:39 -0300
Message-ID: <L10D3.13577$qY3.607222@newscontent-01.sprint.ca>

ROWNUM value calculated before sorting. Unfortunately so.

try

select rownum, a
from (select distinct a from sometable)

Mark

Harlin Setiadarma <harlins_at_bigfoot.com> wrote in message news:37dd0b2b.0_at_news.cbn.net.id...
> 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 - 23:35:39 CDT