SQL Order by , Rownum problem 1

[PeteC1000]

Hi , I am trying to select the first 200 rows from a table with the primary key in sequential order.

Example
Select primary_key#
from table_name
where rownum <=200
order by 1

However, I have realised that rownum is dealt with first by oracle and then the order by clause distorts the result set.

Any help much appreciated on how I could accomplish this ?
I am using Oracle 9.2 but ideally this needs to work with Oracle 7.36 as well.

 

[sem]

Not sure about 7.3, but try

select * from (
Select primary_key#
from  table_name
order by 1)
where rownum <=200

Regards, Dima

http://seminihin.narod.ru

 

[aidystew]

Dima's code should work on oracle 9.2 but won't work on version 7, as you can't put an order by on an inline view in version 7. I know I tried it the other day.