Re: rownum

From: Norris <johnnie_at_cooper.com.hk>
Date: 18 Aug 1999 06:30:49 GMT
Message-ID: <7pdjup$299s$1@adenine.netfront.net>

I am using Oracle 8.0.5. What can I do?

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:

> 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/

> rownum is assigned before the order-by clause is assigned...

> in 8i you can perform things like

> select * from 
>   ( select blah 
>     from   table
>     order by 1,2,3) 

> which would allow the use of rownum like you are after, but if you are

> using some sort of reporting tool, you'd probably be better off using a > built-in facility of the tool to number your records...

> HTH

> -- 
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com

> "Some days you're the pigeon, and some days you're the statue."

Opinions are mine and do not necessarily reflect those of the Corporation.

http://www.ntfaq.com

http://www.jsiinc.com/reghack.htm

http://www.orafaq.org

http://www.oconnell.net/Sybase_FAQ

=============================================================

Received on Wed Aug 18 1999 - 01:30:49 CDT