---------------------------　　建表　　---------------------------

create table test_user

(

id VARCHAR2(12),

name VARCHAR2(32),

age number(2)

)

select t.id,t.name,t.age from test_user t

insert into test_user (ID, NAME,age)

values ('1', '张三',12);

insert into test_user (ID, NAME,age)

values ('2', '李四',12);

insert into test_user (ID, NAME,age)

values ('3', '王五',12);

insert into test_user (ID, NAME,age)

values ('4', '赵六',21);

insert into test_user (ID, NAME,age)

values ('5', '田七',21);

---------------------------　　建表　　---------------------------

select t.*, t.rowid from test_user t order by id

select id,name,age, row_number() over(partition by age order by id desc ) from test_user;

 

partition by 是用来的，用了这个就可以实现在组内进行排序

是用来确定排序的基准的，按照那一列来排序