Every derived table must have its own alias（sql语句错误解决方法）-526互联

1、执行下面语句时，报错Every derived table must have its own alias

select  * from  (select * from jt_notes where createUser = 'b548323007b647809bb8e4192cf44195' limit 0,10)

2、解决方案，加一个别名就可以了

select  * from  (select * from jt_notes where createUser = 'b548323007b647809bb8e4192cf44195' limit 0,10) user