81,122
社区成员




select to_number(substr(dd, 0, instr(t.dd, '-') - 1))as lc
from GWSJ_YDLKJH t
order by lc asc
大家看看我这个有没有优化的
select * from (select * from test_order where dd like '%-%' order by dd) a
union
select * from (select * from test_order where dd like '%#%' order by dd) b