Every derived table must have its own alias
意思为派生出来的表 ,在继续被查询的时候, 都必须有别名
SELECT MAX(edate) FROM (SELECT edate FROM exam WHERE ename='mysql') AS ed
Every derived table must have its own alias
意思为派生出来的表 ,在继续被查询的时候, 都必须有别名
SELECT MAX(edate) FROM (SELECT edate FROM exam WHERE ename='mysql') AS ed