Every derived table must have its own alias (每个派生表必须有自己的别名)
Every derived table must have its own alias (每个派生表必须有自己的别名)
原因
**错误写法**
SELECT SUM( cnts) FROM (SELECT power_type,COUNT(*) cnts FROM ods_jingli GROUP BY power_type)
解决方法
SELECT SUM(a.cnts) FROM (SE...
原创
2019-12-09 17:11:11 ·
192 阅读 ·
0 评论