Re: Sorted results not expected

at to the outer select statement and > see if it works. > > Larry > > > On 3/22/07, Tony Jang <[EMAIL PROTECTED]> wrote: > > hi all > > I used ORDER BY to get sorted results, but why is it not my expect results? > > My database is ORACLE 9. > &g

Sorted results not expected

hi all I used ORDER BY to get sorted results, but why is it not my expect results? My database is ORACLE 9. Any help will be appreciated Below is my sql statement: SELECT * FROM (select rownum rno, a.a aa, a.b ab, a.c ac, b.a ba, b.b bb, b.