有人可以幫我解決我的問題嗎？
我有下表 tw_number
| ID | 價值 |
|---|---|
| 5 | 34 |
| 6 | 555 |
| 6 | 434 |
| 5 | 23 |
| 5 | 43 |
| 5 | 45 |
并想在 MySQL Query 中得到這樣的東西
| ID | 溫度 | 力量 |
|---|---|---|
| 5 | 34 | |
| 6 | 555 | |
| 6 | 434 | |
| 5 | 23 | |
| 5 | 43 | |
| 5 | 45 |
非常感謝！
uj5u.com熱心網友回復：
您可以使用這樣的查詢，但您必須有一個欄位來對輸出進行排序。
SELECT sid
, IF( sid = 5, val,'' ) AS Temperature
, IF( sid = 6, val,'' ) AS POWER
FROM tw_number
ORDER BY id;
如果您只想要 sid 5 或 6，也可以使用它
SELECT sid
, IF( sid = 5, val,'' ) AS Temperature
, IF( sid = 6, val,'' ) AS POWER
FROM tw_number
WHERE sid IN(5,6)
ORDER BY id;
樣本
MariaDB [bernd]> SELECT * FROM tw_number;
---- ----- ------
| id | sid | val |
---- ----- ------
| 1 | 5 | 43 |
| 2 | 6 | 45 |
| 3 | 6 | 45 |
| 4 | 5 | 43 |
| 5 | 5 | 43 |
| 6 | 6 | 45 |
---- ----- ------
6 rows in set (0.00 sec)
MariaDB [bernd]> SELECT sid
-> , IF( sid = 5, val,'' ) AS Temperature
-> , IF( sid = 6, val,'' ) AS POWER
-> FROM tw_number
-> ORDER BY id;
----- ------------- -------
| sid | Temperature | POWER |
----- ------------- -------
| 5 | 43 | |
| 6 | | 45 |
| 6 | | 45 |
| 5 | 43 | |
| 5 | 43 | |
| 6 | | 45 |
----- ------------- -------
6 rows in set (0.00 sec)
MariaDB [bernd]>
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/385453.html
上一篇：.Net啟動程式報錯：It was not possible to find any compatible framework version
下一篇：嘗試將多個外鍵添加到單個表時出錯