select
*
from
question sq
where
sq.bn_id = 183
order by
nvl(length(trim(sq.answers)),0) desc
-- nvl(attribute,default value) 当属性值为空时就将其值设默认值
-- length(attrbute) 得到字符串的长度
-- trim(attribute) 去掉字符的空格
select
*
from
question sq
where
sq.bn_id = 183
order by
nvl(length(trim(sq.answers)),0) desc
-- nvl(attribute,default value) 当属性值为空时就将其值设默认值
-- length(attrbute) 得到字符串的长度
-- trim(attribute) 去掉字符的空格