mysql

一、取出前n条数据 然后分页

SELECT * ,(SELECT a.value FROM blue_base_config a WHERE a.KEY ='sendOrders') AS moneyLevelFROM (SELECT id,orderNo,createDate,expectDate FROM blue_order WHERE getFlag = 3 AND MONTH(createDate)=MONTH(NOW()) AND sid = 1 ORDER BY createDate, id ASC LIMIT 0, 2) AS t UNION SELECT * ,(SELECT a.value FROM blue_base_config a WHERE a.KEY ='spuerOrders') AS moneyLevelFROM (SELECT id,orderNo,createDate,expectDate FROM blue_order WHERE getFlag = 3 AND MONTH(createDate)=MONTH(NOW()) AND sid = 1 ORDER BY createDate, id ASC LIMIT 2, 3) AS t LIMIT 0,1