不是order by的问题,这样试试看
create or replace view rks1 as
select substr(id,1,4)||'00' dzm,count(*) rks
from rk.ren
group by substr(id,1,4)||'00'
order by substr(id,1,4)||'00';
create or replace view rks1 as
select substr(id,1,4)||'00' dzm,count(*) rks
from rk.ren
group by substr(id,1,4)||'00'
order by substr(id,1,4)||'00';
并不真的存放数据
order by 就放在对视图的操作上好了