select * from USER t order by LENGTH(t.login_id);
select * from USER t order by length(trim(t.login_id));
select * from USER t order by nvl(length(trim(t.login_id)),0) desc;
第三种最符合我们的需求要求
select * from USER t order by LENGTH(t.login_id);
select * from USER t order by length(trim(t.login_id));
select * from USER t order by nvl(length(trim(t.login_id)),0) desc;
第三种最符合我们的需求要求