0 Replies - 6480 Views - Last Post: 18 March 2013 - 01:03 AM

#1 nazirul_137  Icon User is offline

  • New D.I.C Head

Reputation: -1
  • View blog
  • Posts: 15
  • Joined: 06-February 13

How to separate data to another colum at table?

Posted 18 March 2013 - 01:03 AM

example my data in oracle:
----------------------
| col1 | col2 | col3 |
----------------------
| A | 1 | 1 |
| A | 2 | 2 |
| B | 3 | 3 |
| B | 4 | 4 |
| C | 5 | 5 |
| C | 6 | 6 |
----------------------

table result on my web page is:
----------------------
| out1 | out2 | out3 |
----------------------
| A | | |
| B | | |
| C | | |
----------------------

the result that i want is the data should be like this:
----------------------
| out1 | out2 | out3 |
----------------------
| A | B | C |
| A | B | C |
----------------------

Is This A Good Question/Topic? 0
  • +

Page 1 of 1