select aa,substr(' '||aa,length(aa)-4) as aar4 from t1 order by aar4
改
select aa,substr(' '||aa,length(' '||aa)-4) as aar4 from t1 order by aar4
-----------------------------
我流落在凄凉的世界里-孤苦伶仃
我过着动荡无助的生活-四处漂泊
我在死亡线上苦苦挣扎-度日如年
select aa,substr(aa,length(aa)-4) as aar4 from t1 order by aar4
或
select aa,substr(' '||aa,length(aa)-4) as aar4 from t1 order by aar4
-----------------------------
我流落在凄凉的世界里-孤苦伶仃
我过着动荡无助的生活-四处漂泊
我在死亡线上苦苦挣扎-度日如年
也可以尝试改成select aa,right(aa,4) as aar4 from t1 order by aar4
或select aa from (select aa,right(aa,4) as aar4 from t1 order by aar4)
-----------------------------
我流落在凄凉的世界里-孤苦伶仃
我过着动荡无助的生活-四处漂泊
我在死亡线上苦苦挣扎-度日如年