2019-01-24
閱讀量:
790
mysql 子查詢錯(cuò)誤 error 1248 :
ERROR 1248(42000):Every derived table must have its own alias

答:提示你沒(méi)有給子查詢起別名,所以需要按下面代碼修改即可
select count(*) from (select plaza_name,count(plaza_name) from exit_tran group by plaza_name) as test;






評(píng)論(0)


暫無(wú)數(shù)據(jù)
CDA考試動(dòng)態(tài)
CDA報(bào)考指南
推薦帖子
0條評(píng)論
0條評(píng)論
0條評(píng)論
1條評(píng)論