sql语句查询,limit与order by 同时出现,应该order by在前面

eg:select orderid,status,createtime from orders where appid = :appId and userid = :userId order by createtime desc limit :page,:pageSize;

小细节,注意一下

posted @ 2014-07-30 14:44  luoluo,keep moving...  阅读(1551)  评论(0编辑  收藏  举报