mysql - 当我确实有别名时，每个派生表都必须在 mysql 中有自己的别名错误

Question

我不断收到此错误，并且声明了别名？任何帮助，将不胜感激。

CREATE VIEW maxJokes AS 
SELECT MAX(num) FROM 
( SELECT J.postUserID, count(*) AS num 
  FROM JokeTable J WHERE J.date >= '2018-03-01' 
  GROUP BY J.postUserID
)

标签： mysql

Answer 1

您必须在子查询中添加别名

CREATE VIEW maxJokes AS 

SELECT MAX(num) FROM 
( 
   SELECT J.postUserID, count(*) AS num 
   FROM JokeTable J WHERE J.date >= '2018-03-01'
   GROUP BY J.postUserID
)A