@rownum

最新推荐文章于 2023-09-26 10:30:48 发布

小德的程序人生

最新推荐文章于 2023-09-26 10:30:48 发布

阅读量1.1k

点赞数 1

分类专栏： Mysql

本文链接：https://blog.csdn.net/wangde962557361/article/details/78355172

版权

Mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

SELECT
	*
FROM
	(
		SELECT
			@rownum := @rownum + 1 AS now_sort_index,
			t.*
		FROM
			(SELECT @rownum := 0) r,
			(
				SELECT
					p.product_id,
					p.sort_index
				FROM
					mall_product p
				WHERE
					1 = 1
				AND p.validity = 'VALID'
				AND p.category_id = 'e1927ee2-4d2a-11e5-8922-02004c4f4f50'
				AND p.product_status = 'OPEN'
				ORDER BY
					p.sort_index ASC,
					p.last_modify_time DESC
			) t
	) t
WHERE
	t.sort_index != t.now_sort_index