MYSQL分组获取前3 条数据

SELECT * FROM (
	SELECT 
	IF(@t=CONCAT(SALE_HISTORY_ID,CREATE_BY),@r:=@r + 1,@r:=1) as rowNum,@t:=CONCAT(SALE_HISTORY_ID,CREATE_BY) as tmp,
	SALE_HISTORY_ID,CREATE_BY,PRICE,CREATE_TIME
	FROM SP_BID_RECORD,(SELECT @t:=null,@r := 0) r WHERE SALE_HISTORY_ID IN ('20190612105444FCBBFC6BF33B623F0A') 
	ORDER BY SALE_HISTORY_ID,CREATE_BY,PRICE DESC
) B WHERE rowNum = 1;