1、创建一个student，并且插入数据
create table student(name varchar(12),age int) insert into student values(‘z1‘,‘1‘); insert into student values(‘z2‘,‘6‘); insert into student values(‘z3‘,‘2‘); insert into student values(‘z4‘,‘3‘); insert into student values(‘z5‘,‘7‘); commit;
2、直接按照age进行排序显示行号：
select * from(select rownum rw,t.* from student t order by t.age asc)
3另一种查询，能够很好地查找：
select row_number() over( order by t.age asc) rw,t.* from student t
原文：http://www.cnblogs.com/dragkiss/p/4137180.html