ORACLE sqL 查询一张表中，字段id最大值的那条记录。 table表里有id,和time两 select max（id）form table
供稿：hz-xin.com 日期：2024-05-18
sql=sql&" "是什么意思
select time from table t1
where not exists (select 1 from table where id > t1.id)
或者
select time from table where id in (select max(id) from table)
select idTIME form table where rownum=1 order by id desc;
where not exists (select 1 from table where id > t1.id)
或者
select time from table where id in (select max(id) from table)
select idTIME form table where rownum=1 order by id desc;