SQLServer分页

http://blog.csdn.net/qiaqia609/article/details/41445233

?

SELECT
	urt.id,urt.user_id userId,urt.source_id sourceId,urt.trade_fee tradeFee,urt.total_balance totalBalance,urt.gmt_trade gmtTrade,urt.trade_type tradeType,urt.remarks,urt.flag,urt.audit_name auditName,urt.audit_reasons auditReasons,urt.gmt_audit gmtAudit,urt.pay_status payStatus,urt.payer,urt.gmt_pay gmtPay,pay_info payInfo
FROM
	xy_user_reward_trade urt,(
		SELECT
			TOP 6 row_number () OVER (ORDER BY id ASC) row_num,id
		FROM
			xy_user_reward_trade
	  WHERE
			trade_type != 0
	) urt2
WHERE
	urt.id = urt2.id
AND urt2.row_num > 3
ORDER BY
	urt2.row_num ASC

SELECT
	urt.id,id
		FROM
			xy_user_reward_trade
	) urt2
WHERE
	urt.id = urt2.id and trade_type != 0
AND urt2.row_num > 3
ORDER BY
	urt2.row_num ASC

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!