mysql查询排名根据数据

最新推荐文章于 2024-07-30 03:42:15 发布

夏天吹雪

最新推荐文章于 2024-07-30 03:42:15 发布

阅读量698

点赞数

分类专栏：工作随记

本文链接：https://blog.csdn.net/qq_39723363/article/details/82181510

版权

工作随记专栏收录该内容

27 篇文章 1 订阅

订阅专栏

SELECT id, user_id, integral, total_day,
	total_integral,
	ranking,
	create_time,
	update_time
FROM
	(
		SELECT
			a.id,
			a.user_id,
			a.integral,
			a.total_day,
			a.total_integral,
			a.create_time,
			a.update_time,
			(@rowno :=@rowno + 1) AS ranking
		FROM
			activity_sign_in a,
			(SELECT(@rowno := 0)) b
		ORDER BY
			a.create_time ASC,
			a.id ASC
	) c
WHERE
	c.user_id = '161'

根据条件查询排名

SELECT id, user_id, integral, total_day,
	total_integral,
	ranking,
	create_time,
	update_time
FROM
	(
		SELECT
			a.id,
			a.user_id,
			a.integral,
			a.total_day,
			a.total_integral,
			a.create_time,
			a.update_time,
			(@rowno :=@rowno + 1) AS ranking
		FROM
			activity_sign_in a,
			(SELECT(@rowno := 0)) b
		ORDER BY
			a.create_time ASC,
			a.id ASC
	) c

查询数据排名