oracle一组数中找最大

select jobname  ,length(jobname) from bd_jobbasfil where length(jobname) in (select max(length(jobname))from bd_jobbasfil)

不需要什么复杂的sql。

但是不能这样写  select jobname  from bd_jobbasfil where length(jobname) =max(length(jobname) )