select rownum ,id,name from student order by name(或者by其他的)
select rownum ,id,name from (select * from student order by name);
select rownum ,id,name from student order by name(或者by其他的)
select rownum ,id,name from (select * from student order by name);