oracle中选出某个字段里面最大值的记录的sql语句怎么写
最新回答
初心
2026-10-20 16:12:20
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;
姐丶心已打烊
2026-08-02 19:14:49
SELECT a.*
FROM table1 a WHERE NOT
EXISTS (SELECT 1 FROM table1 b WHERE b.id>a.id)
或者
SELECT *
FROM table1 WHERE id IN
(SELECT Max(id) FROM table1)
又或者
SELECT *
FROM table1 WHERE id=(SELECT Max(id) FROM table1)
热门标签
