Order By Problem

Hi, All:

Oracle does not allow to use Order By clause in subquery, how do I solve the problem?
what I want is something like this:

select * from (select x.*, rownum r from foo

                      order by col1);

Thanks. Received on Mon Jan 17 2000 - 17:46:18 CST