oracle中選出某個字段裏面最大值的記錄的sql語句怎麽寫

1、創建測試表，

create table test_max(id number, value number);

2、插入測試數據

insert into test_max values(1,12);

insert into test_max values(2,100);

insert into test_max values(3,55);

insert into test_max values(4,100);

insert into test_max values(5,50);

commit;

3、查詢表中全量數據，select t.*, rowid from test_max t;

4、編寫sql，使用rank分析函數，取value值為最大的記錄; select t.* from (select t.*, rank() over(order by value desc) rk from test_max t) t where rk = 1;