Oracle Line number sorting problem

1. Create a student and insert the data

Create TableStudent (namevarchar( A), ageint)Insert  intoStudentValues('Z1','1');Insert  intoStudentValues('Z2','6');Insert  intoStudentValues('Z3','2');Insert  intoStudentValues('Z4','3');Insert  intoStudentValues('Z5','7');Commit;

2. Sort by age directly displays line numbers:

Select *  from (Select rownum rw,t.*fromorderbyASC)

3 Another query that can be well looked up:

Select  Over Order  by ASC) Rw,t.* from student t

Oracle Line number sorting problem