选出每天的TOP3

查询语句

SELECT date,user, num FROM (
	SELECT
		date,
		user,
		num,
		CASE WHEN @date=date  THEN @ord:=@ord+1 ELSE @ord:=1 END as ord,
		@date:=date as date1,
		@num:=num as num1
	FROM(
		SELECT
			DATE date,
			USER user,
			count(USER) num
		FROM
			logs
		WHERE
			DATE BETWEEN '2021-05-20'
			AND '2021-05-22'
			GROUP BY DATE,USER
			ORDER BY DATE,num DESC
	)a,
	(SELECT @date:='',@num:='',@ord:=0)b
)c WHERE ord<=3

查询结果

表数据