OraFAQ Forum: Server Administration » Re: serial number in SQL reports

Home » RDBMS Server » Server Administration » Re: serial number in SQL reports

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: serial number in SQL reports [message #373606]

Thu, 26 April 2001 03:03

Neal Hawman
Messages: 14
Registered: April 2001

Junior Member

I can only assume you have a different version of Oracle to me. Here are the results of running a similar query on my 8.1.6.2 system:

SQL> l
1 select account_num, rownum from account
2* order by account_num desc
SQL> /

ACCOUNT_NUM ROWNUM
----------- ----------
21651 1
21650 2
21649 3
21648 4
21647 5
21646 6

If I change the "order by" to asc, I get:

1 select account_num, rownum from account
2* order by account_num asc
SQL> /

ACCOUNT_NUM ROWNUM
----------- ----------
20178 1
20179 2
20180 3
20181 4
20182 5
20183 6

Report message to a moderator

Previous Topic:	RDBMS_ SQL_Related question_Fundamentals
Next Topic:	UNICODE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 00:22:20 CDT 2024