| Re: serial number in SQL reports [message #373612] |
Thu, 26 April 2001 12:08 |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
My example was run in 8.1.5
Can you re-check with this test to see if you still get a different result? I seem to remember reading something like what you are experiencing.
create table tst (x number);
insert into tst values (1);
insert into tst values (9);
insert into tst values (3);
commit;
-- table not analyzed, so RULE optimizer.
-- no indexs either.
select x, rownum from tst order by x desc;
9 2
3 3
1 1
select qry.x, rownum from (select x from tst order by x) qry;
1 1
3 2
9 3
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
