samedi 27 décembre 2014

how to create pivot query for this result?

I got result from query:



TITAL PCS RGH_CTS VALUE
SEND 10 49.8550 198742.94400
BID 15 76.7070 327461.76300
FINAL 19 88.5630 337954.15600


I want this output - How to solve this?



| TITAL | SEND | BID | FINAL |
| PCS | 10 | 15 | 19 |
| RGH_CTS | 49.8550 | 76.7070 | 88.5630 |
| VALUE | 198742.94400 | 327461.76300 | 337954.15600 |


Any body can solve this simple query?


Aucun commentaire:

Enregistrer un commentaire