MySQL 查询结果再反序

１、取数据库最后３０个数据

?

1	select x,y from sin order by id desc limit 0,30;

 

2、将数据再反序,横坐标反转

?

1 2	select * from (select x,y from sin order by id desc limit 0,30) as sinxy order by sinxy.x asc ;