Every derived table must have its own alias

Every derived table must have its own alias

如下SQL语句: SELECT * FROM ( SELECT ID,URL FROM alone_action WHERE STATE = 1 ) 在Oracle中可以执行,但在MySQL下无法通过,错误如下: 查询:SELECT * FROM ( SELECT ID,URL FROM alone_action WHERE STATE = 1 ) LIMIT 0, 1000 错误代码: