Oracle取查询结果第一条记录SQL

最新推荐文章于 2024-06-27 16:43:53 发布

Nocturne2011

最新推荐文章于 2024-06-27 16:43:53 发布

阅读量5.4k

点赞数 3

分类专栏： Oracle 文章标签： oracle select sql

本文链接：https://blog.csdn.net/qiuzhping/article/details/37930065

版权

Oracle 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

Oracle取查询结果第一条记录SQL

select * from (  select e.id,e.filename,e.status,e.version,e.url,e.file_type,   (select max(e.version) from eig_upload e   where e.file_type = 1  and e.game_id = '4028822f46d66cf70146d66fe69e0002') as times   from eig_upload e   where e.file_type = 1  and e.game_id = '4028822f46d66cf70146d66fe69e0002'  and e.status = 1  order by e.update_time DESC )   where rownum = 1