热线电话:13121318867

登录
2019-01-24 阅读量: 697
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.0000
4
关注作者
收藏
评论(0)

发表评论

暂无数据
推荐帖子