这样写不行,认为金额是一个变量
SELECT 编号, sum(本金) AS 金额 FROM sk GROUP BY 编号 ORDER BY 金额
只有这样
select * from (SELECT 编号, sum(本金) AS 金额 FROM sk GROUP BY 编号) ORDER BY 金额
转载于:https://www.cnblogs.com/vincentfeng/archive/2009/11/05/1596754.html
转载于:https://www.cnblogs.com/vincentfeng/archive/2009/11/05/1596754.html