dimanche 17 juillet 2016

Split a column into 3 columns?

I have table 1 like this:

----------------
|  id  |  col  |
----------------
|   1  |   7   |
|   2  |   6   |
|   3  |   1   |
|   4  |   8   |
|   5  |   9   |
|   6  |   5   |
|   7  |   4   |
|   8  |   3   |
|   9  |   2   |
----------------

I want to create new table get data from column col of table 1 and get the result like this:

-------------------
|  A  |  B  |  C  |
-------------------
|  7  |  6  |  1  |
|  8  |  9  |  5  |
|  4  |  3  |  2  |
-------------------

Any suggestions? Thanks a lot.

Aucun commentaire:

Enregistrer un commentaire