模板
select * from (select A from TABLE order by TIME desc) where rownum = 1
例子
表结构
查询最新的一条FROM_ID记录
select * from
(select form_id from formid where user_id = '28be9d85d0764c518ca074832fbad1b6' order by insert_time desc)
where rownum = 1
查询到记录
1、select kd.CREATEUSERID as userid,kd.LOCATION,kd.createtime as location from KT_DEVICESTRACK kd where rownum=1 order by kd.createtime
2、SELECT * FROM (
SELECT *,ROWNUM rn FROM t ORDER BY date_col DESC
) WHERE rn = 13、update cg_berthtrace cg set cg.chagedtime=sysdate,cg.parkduration=(cg.chagedtime-cg.createtime)*24*60,cg.berthstatus='11'
where cg.berthno in(select po.bowei from pda_order po where po.starttime=(select max(starttime) from pda_order))