rownum

From: Norris <johnnie_at_cooper.com.hk>
Date: 15 Aug 1999 07:53:58 GMT
Message-ID: <7p5rmm$75a$1@imsp009a.netvigator.com>

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/ Received on Sun Aug 15 1999 - 02:53:58 CDT