用嵌套查询时,会报错每一个派生出来的表都必须有一个自己的别名
SELECT * from(SELECT QUARTER(updateDate) updateDate,sum(num) value FROM study_table GROUP BY updateDate) WHERE updateDate = 3;
解决办法:在第一层查询结果加一个别名a即可,如下:
SELECT * from(SELECT QUARTER(updateDate) updateDate,sum(num) value FROM study_table GROUP BY updateDate) a WHERE updateDate = 3;