weixin_38369037 2018-11-28 03:24 采纳率: 60%
浏览 203

msql union 行号被重置

SELECT
A.activationNum,
A.qbid,
A.uin,
A.cn,
A.rankingsNum,
A.POINT AS point
FROM
(
(
SELECT
activationNum,
qbid,
uin,
cn,
createTime,
(@i :=@i + 1) AS rankingsNum,
POINT
FROM
(
SELECT
COUNT(1) AS activationNum,
t.qbid,
c.uin,
c.cn,
c.CREATE_TIME AS createTime,
p.POINT
FROM
t_activity_ticket t,
cn_bind c,
cb_point_1 p
WHERE
t.uin = c.UIN
AND c.UIN = p.UIN
AND t. STATUS = 1
AND t.qbId = 1
GROUP BY
c.uin,
t.qbid
ORDER BY
p.POINT DESC
-- LIMIT 10
) B,
(SELECT @i := 0) it
)
UNION
(
SELECT
activationNum,
qbid,
uin,
cn,
createTime,
(@i :=@i + 1) AS rankingsNum,
POINT
FROM
(
SELECT
COUNT(1) AS activationNum,
t.qbid,
c.uin,
c.cn,
c.CREATE_TIME AS createTime,
p.POINT
FROM
t_activity_ticket t,
cn_bind c,
cb_point_2 p
WHERE
t.uin = c.UIN
AND c.UIN = p.UIN
AND t. STATUS = 1
AND t.qbId = 2
GROUP BY
c.uin,
t.qbid
ORDER BY
p.POINT DESC
-- LIMIT 10
) B,
(SELECT @i := 0) it
)
UNION
(
SELECT
activationNum,
qbid,
uin,
cn,
createTime,
(@i :=@i + 1) AS rankingsNum,
POINT
FROM
(
SELECT
COUNT(1) AS activationNum,
t.qbid,
c.uin,
c.cn,
c.CREATE_TIME AS createTime,
p.POINT
FROM
t_activity_ticket t,
cn_bind c,
cb_point_3 p
WHERE
t.uin = c.UIN
AND c.UIN = p.UIN
AND t. STATUS = 1
AND t.qbId = 3
GROUP BY
c.uin,
t.qbid
ORDER BY
p.POINT DESC

                ) B,
                (SELECT @i := 0) it
        )
) A 
期望结果 rankingsNum 1 1 1 2
现在结果 rankingsNum 1 2  3 4
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面
    • ¥50 NT4.0系统 STOP:0X0000007B
    • ¥15 想问一下stata17中这段代码哪里有问题呀
    • ¥15 flink cdc无法实时同步mysql数据
    • ¥100 有人会搭建GPT-J-6B框架吗?有偿
    • ¥15 求差集那个函数有问题,有无佬可以解决
    • ¥15 【提问】基于Invest的水源涵养
    • ¥20 微信网友居然可以通过vx号找到我绑的手机号
    • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
    • ¥15 解riccati方程组