《Mysql實(shí)例mysql中ROLLUP的替代方法(實(shí)例)》要點(diǎn)：
本文介紹了Mysql實(shí)例mysql中ROLLUP的替代方法(實(shí)例)，希望對(duì)您有用。如果有疑問(wèn)，可以聯(lián)系我們。
導(dǎo)讀：從MySQL中提取數(shù)據(jù),使用ROLLUP統(tǒng)計(jì)后,想在數(shù)據(jù)左邊列中加入項(xiàng)目名稱(chēng),使用SQL：
SELECT (CASE WHEN ISNULL(PLAYERNO) THEN PLAYERNO=...
MYSQL教程從MySQL中提取數(shù)據(jù),使用ROLLUP統(tǒng)計(jì)后,想在數(shù)據(jù)左邊列中加入項(xiàng)目名稱(chēng),使用SQL：
?
SELECT (CASE WHEN ISNULL(PLAYERNO) THEN PLAYERNO='TOTAL' ELSE PLAYERNO END) AS PLAYERNO,SUM(AMOUNT) FROM penalties?
GROUP BY PLAYERNO WITH ROLLUP?
MYSQL教程輸出結(jié)果：
?
+----------+-------------+
| PLAYERNO | SUM(AMOUNT) |
+----------+-------------+
|??????? 6?? |????? 100.00 |
|??????? 8?? |??????? 25.00 |
|?????? 27? |????? 175.00 |
|?????? 44? |????? 130.00 |
|????? 104 |??????? 50.00 |
|???? NULL|????? 480.00 |
+----------+-------------+
6 rows in set, 1 warning (0.00 sec)
?
MYSQL教程顯示為空值,修改如下：
?
SELECT PLAYERNO,SUM(AMOUNT) FROM penalties?
GROUP BY PLAYERNO?
UNION?
SELECT 'TOTAL',SUM(AMOUNT)?
FROM penalties?
?
MYSQL教程顯示結(jié)果：
?
+----------+-------------+
| PLAYERNO | SUM(AMOUNT) |
+----------+-------------+
| 6????????? |????? 100.00 |
| 8????????? |??????? 25.00 |
| 27??????? |????? 175.00 |
| 44??????? |????? 130.00 |
| 104????? |??????? 50.00 |
| TOTAL? |????? 480.00 |
+----------+-------------+
6 rows in set (0.00 sec)
MYSQL教程問(wèn)題：雖然這樣也可以顯示出數(shù)據(jù),但卻沒(méi)有了ROLLUP的簡(jiǎn)潔,哪位有更好的辦法,歡迎分享下.
《Mysql實(shí)例mysql中ROLLUP的替代方法(實(shí)例)》是否對(duì)您有啟發(fā)，歡迎查看更多與《Mysql實(shí)例mysql中ROLLUP的替代方法(實(shí)例)》相關(guān)教程，學(xué)精學(xué)透。維易PHP學(xué)院為您提供精彩教程。
轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/12749.html
