SELECT b.* from
(
SELECT
A.*,
CASE
WHEN @mid = pay_sort THEN
@ROW := @ROW + 1 ELSE @ROW := 1
END rownum,
@mid := pay_sort
FROM
table, (select @ROW:=0) t
) b where 1 = 1
limit #{pageStart},#{pageEnd}
mysql 查询结果显示行号,并limit 分页
最新推荐文章于 2024-06-01 13:03:59 发布