Re: rownum

Norris wrote:
>
> I want to use rownum as the sequence number in the report but the result
> is not what I expect. What can I do?
>
> ------------------------------------------
> drop table abc
> /
> create table abc (a char(1))
> /
> insert into abc values ('B')
> /
> insert into abc values ('A')
> /
> select rownum,a
> from abc
> order by a
> /
> ROWNUM A
> ---------- -
> 2 A
> 1 B
> 2 rows selected.
>
> --
> --
> http://www.washington.edu/pine/faq/

Norris,

The first record you inserted gets rownum 1, the second one rownum 2.

Maarten Received on Tue Aug 17 1999 - 01:13:29 CDT