有没有sql大神啊问个问题【java吧】

11月24日漏签0天

java吧关注：1,288,929贴子：12,815,149

10回复贴，共1页

<返回java吧

有没有sql大神啊问个问题

只看楼主收藏回复

只有1月份有数据怎么改sql才能变成 1-10911.00， 2-null， 3-null啊

送TA礼物

1楼2018-08-07 19:43回复

弄了一下午了没弄出来要吐了

2楼2018-08-07 19:43

不感兴趣

开通SVIP免广告

没人嘛是不是这种sql不可能存在的啊

3楼2018-08-07 19:47

IP属地:广西

4楼2018-08-07 22:11

SELECT
MONTH (input_time) AS mon,
sum(vol_amount) AS total
FROM
test
WHERE
input_time BETWEEN '2017-01-01'
AND '2017-02-01'
GROUP BY
input_time
UNION ALL
SELECT DISTINCT
1 AS mon,
NULL AS total
FROM
test
WHERE
(
SELECT
MONTH (input_time) AS mon
FROM
test
WHERE
input_time BETWEEN '2017-01-01'
AND '2017-02-01'
GROUP BY
input_time
) IS NULL
UNION ALL
SELECT
MONTH (input_time) AS mon,
sum(vol_amount) AS total
FROM
test
WHERE
input_time BETWEEN '2017-02-01'
AND '2017-03-01'
GROUP BY
input_time
UNION ALL
SELECT DISTINCT
2 AS mon,
NULL AS total
FROM
test
WHERE
(
SELECT
MONTH (input_time) AS mon
FROM
test
WHERE
input_time BETWEEN '2017-02-01'
AND '2017-03-01'
GROUP BY
input_time
) IS NULL
UNION ALL
SELECT
MONTH (input_time) AS mon,
sum(vol_amount) AS total
FROM
test
WHERE
input_time BETWEEN '2017-03-01'
AND '2017-04-01'
GROUP BY
input_time
UNION ALL
SELECT DISTINCT
3 AS mon,
NULL AS total
FROM
test
WHERE
(
SELECT
MONTH (input_time) AS mon
FROM
test
WHERE
input_time BETWEEN '2017-03-01'
AND '2017-04-01'
GROUP BY
input_time
) IS NULL

IP属地:广西

5楼2018-08-07 22:12