2019-01-24
阅读量:
734
mysql 子查询错误 error 1248 :
ERROR 1248(42000):Every derived table must have its own alias

答:提示你没有给子查询起别名,所以需要按下面代码修改即可
select count(*) from (select plaza_name,count(plaza_name) from exit_tran group by plaza_name) as test;






评论(0)


暂无数据
推荐帖子
0条评论
0条评论
0条评论