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