作者: hold_find 時間: 2017-8-28 12:37 標題: 求教SQL, row 變column
本帖最後由 hold_find 於 2017-8-28 12:41 編輯
table 有如下
member, work
member
| name | id |
| Peter | 123 |
| John | 124 |
| Tom | 125 |
work
| id | year | work |
| 123 | 2015 | Peter work 1 |
| 123 | 2016 | Peter work 2 |
| 123 | 2017 | Peter work 3 |
| 124 | 2015 | John work 1 |
| 124 | 2016 | John work 2 |
現在想output Peter和John的2016前首5工作記錄，按year倒序排
| name | id | work1 | work1 year | work2 | work2 year | work3 | work3 year | work4 | work4 year | work5 | work5 year |
| Peter | 123 | Peter work 2 | 2016 | Peter work 1 | 2015 | - | - | - | - | - | - |
| John | 124 | John work 2 | 2016 | John work 1 | 2015 | - | - | - | - | - | - |
SQL可以怎樣寫?
DB是oracle不知怎樣可以row 變column地output出來...
thx
作者: 7h1r733n 時間: 2017-8-31 09:40
https://blogs.oracle.com/sql/how ... a-pivot-and-unpivot