56,677
社区成员
发帖
与我相关
我的任务
分享
SELECT
@rank:=@rank+1 AS `排名`,
TT.账号,
TT.姓名,
TT.累计销售
FROM
(SELECT
loginAccount AS `账号`,
operator AS `姓名`,
Sum(Gold) AS `累计销售`
FROM
rechargelog
ORDER BY
`累计销售` DESC
) AS TT,(SELECT @rank:=0) B
select
1,
'wanglaowu',
'老王',
390
union
SELECT
@rank:=@rank+1 AS `排名`,
TT.账号,
TT.姓名,
TT.累计销售
FROM
(SELECT
loginAccount AS `账号`,
operator AS `姓名`,
Sum(Gold) AS `累计销售`
FROM
rechargelog
ORDER BY
`累计销售` DESC
) AS TT,(SELECT @rank:=1) B