select * from table where describe=(select max(length(describe)) from table)
如果不希望看到NULL的话,可以在子查询中屏蔽NULL select * from (select name,describe from table where describe is not null order by lengthb(describe) desc) where rownum<=1;
上面那个可以控制看到多少行,如果只需要知道最大行的话,这样写效率更高一些: select * from table where lengthb(describe)=(select max(lengthb(describe)) from table);
select * from (select name,describe from table where describe is not null order by lengthb(describe) desc) where rownum<=1;
select * from table where lengthb(describe)=(select max(lengthb(describe)) from table);