1、先order by 排序一下这个字段!
select T.*
from 表 t
order by t.val2、数字和日期样子的应该在前面,之后手工查到字符类型的数据前一个number,如19:
select T.*
from
(select T.*
from 表 t
order by t.val)
where rownum<=19
3、追加剔除带‘/‘的日期型数据,之后可以to_number()了:
select T.*
from
(select T.*
from 表 t
order by t.val)
where rownum<=19
and instr(t.val,'/')<1
and to_number(val)>7
select T.*
from 表 t
order by t.val2、数字和日期样子的应该在前面,之后手工查到字符类型的数据前一个number,如19:
select T.*
from
(select T.*
from 表 t
order by t.val)
where rownum<=19
3、追加剔除带‘/‘的日期型数据,之后可以to_number()了:
select T.*
from
(select T.*
from 表 t
order by t.val)
where rownum<=19
and instr(t.val,'/')<1
and to_number(val)>7
select a.*
from
(select *
from 表 t
where ltrim(trim(val),'0123456789') is null
) a
where to_number(trim(a.val)) > 7