我有以下結果：
-------------------------
| dept | Active request |
-------------------------
| AFG | 3 |
| AGO | 4 |
| KMN | 1 |
| MOL | 1 |
| POD | 2 |
| SUD | 2 |
-------------------------
我怎樣才能把它改造成類似的東西
--------------------------------------------------------------
| Title | AFG | AGO | KMN | MOL | POD | SUD | TOTAL |
--------------------------------------------------------------
| Active Request | 3 | 4 | 1 | 1 | 2 | 2 | 13 |
--------------------------------------------------------------
這是我的小提琴http://sqlfiddle.com/#!9/b51a03/3
uj5u.com熱心網友回復：
您可以使用單個資料透視查詢：
SELECT
'Active Request' AS Title,
COUNT(*) FILTER (WHERE dept = 'AFG') AS AFG,
COUNT(*) FILTER (WHERE dept = 'AGO') AS AGO,
COUNT(*) FILTER (WHERE dept = 'KMN') AS KMN,
COUNT(*) FILTER (WHERE dept = 'MOL') AS MOL,
COUNT(*) FILTER (WHERE dept = 'POD') AS POD,
COUNT(*) FILTER (WHERE dept = 'SUD') AS SUD,
COUNT(*) AS TOTAL
FROM req
WHERE active;
uj5u.com熱心網友回復：
這可以通過 postgresql 交叉表函式來完成。
您可以在以下位置找到詳細說明：PostgreSQL 中的資料透視表使用交叉表函式
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/504839.html
標籤：PostgreSQL 交叉表