sql分頁(yè)愤惰,頂置(項(xiàng)目環(huán)境內(nèi)不支持)苇经,if后,1代表頂置宦言,0代表底置
<select id="selectPageList" resultType="com.pig4cloud.pigx.e_ticket.entity.OrderManage">
SELECT
id,
order_no,
business_no,
hold_name,
business_money,
estimated_premium,
premium_amount,
issue_date,
maturity_date,
order_status,
redemption_voucher_status,
redemption_voucher_path,
redemption_voucher_date,
create_time,
update_time,
remark
FROM
order_manage
<where>
${ew.sqlSegment}
</where>
ORDER BY
IF
( order_status = 7 OR order_status = 8, 1, 0 ) ,
create_time DESC
</select>