根据销售金额查询业绩排名
select @n:=@n+1 rank,t.amount from
(select * from sale_data
group by user_id order by amount desc) t,(select @n:= 0) d
结果如下:
根据销售金额查询业绩排名
select @n:=@n+1 rank,t.amount from
(select * from sale_data
group by user_id order by amount desc) t,(select @n:= 0) d
结果如下: