mysql子查询 order by 不生效问题

select * from (select * from atable order by id asc limit 0,999999999)

没有limit 排序不会生效