1. order by 别名报错“Unknown column 't.gsort' in 'order clause'”
错误写法:select id, (c1 + c2) as s from t1 order by t1.s desc
换种写法:select id, (c1 + c2) as s from t1 order by (c1 + c2) desc
版权声明：本文为lvhui321原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。
1. order by 别名报错“Unknown column 't.gsort' in 'order clause'”
错误写法:select id, (c1 + c2) as s from t1 order by t1.s desc
换种写法:select id, (c1 + c2) as s from t1 order by (c1 + c2) desc