22,206
社区成员
发帖
与我相关
我的任务
分享
select SUM(num) as a1
FROM table1
where dayid IN (1,2) AND UserID = 1
select SUM(num) as a2
FROM table1
where dayid IN (3,4) AND UserID = 1
.
.
.
.
select SUM(num) as a51
FROM table1
where dayid IN (101,102) AND UserID = 1
SELECT
SUM(CASE WHEN dayid IN (1,2) THEN num ELSE 0 END) AS a1,
SUM(CASE WHEN dayid IN (3,4) THEN num ELSE 0 END) AS a2,
.............
SUM(CASE WHEN dayid IN (101,102) THEN num ELSE 0 END) AS a51
FROM table1
WHERE UserID = 1
不用group by, sum计算总和SELECT
SUM(CASE WHEN dayid IN (1,2) THEN num ELSE 0 END) AS a1,
SUM(CASE WHEN dayid IN (3,4) THEN num ELSE 0 END) AS a1,
SUM(CASE WHEN dayid IN (5,6) THEN num ELSE 0 END) AS a1,
.............
SUM(CASE WHEN dayid IN (101,102) THEN num ELSE 0 END) AS a51
FROM table1
WHERE UserID = 1