Re: HELP !!!!!!

try ....

select a.col1
from (select col1 col2 from table a

        order by col1) a
where rownum <=100;

I think this will work. The order by is the problem in that you have to do it in the subquery rather than the main query.

Robert Received on Sun Jul 04 1999 - 18:58:50 CDT