select *
from (select a.*,rownum arownum
from (select u.*,(case u.TR_LEVEL
when 0 then
'无'
else "其他"
end) tlevel
from TABLE u
where delflag = 0
order by id desc) a)
where arownum between 1 and 10
order by arownum