
select sum(money) sum from (select * from guest limit 0,10),
在mysql数据库运行会报错!Every derived table must have its own alias,
主要原因是你缺少一个临时的表名,
你只需要在最结尾加上一个临时表名就ok了!
正确结果:select sum(money) sum from (select * from guest limit 0,10)t;
在mysql数据库运行会报错!Every derived table must have its own alias,
主要原因是你缺少一个临时的表名,
你只需要在最结尾加上一个临时表名就ok了!
正确结果:select sum(money) sum from (select * from guest limit 0,10)t;
