MySQL 子查詢(sub query) limit 的用法

select * from (select * from table order by a limit 100 ) as newtable order by newtable.b

newtable 是一個別名，取什麼都可以
原因是：
error(#1248 Every derived table must have its own alias)