注意处理数据前字段里是否有空格
select id, case when length(id) = 4 then ' ' when length(id) = 6 then ' ' when length(id) = 8 then ' ' when length(id) = 10 then ' ' end || name from ZB t order by id
注意处理数据前字段里是否有空格
select id, case when length(id) = 4 then ' ' when length(id) = 6 then ' ' when length(id) = 8 then ' ' when length(id) = 10 then ' ' end || name from ZB t order by id