Go up
Convert Rows into Columns
| Subject: |
Convert Rows into Columns |
| Author: |
swathi sharma, India |
| Date: |
Feb 09, 2010, 211 days ago |
| Os info: |
Linux |
| Oracle info: |
Oracle 10G |
| Message: |
Hi
I Have data like this in a table
1501-2001 2001-3000 3001-4000 4001-5000
1 2 3 3
0 25 45 60
0 50 135 180
Now i want this in the below way
Range Emps Rate of Tax Total
1501-2001 1 0 0
2001-3000 2 25 50
3001-4000 3 45 135
4001-5000 3 60 180
Solution would be appreciated
Thanks in advance
Swati
|
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: Convert Rows into Columns |
| Author: |
Michel Cadot, France |
| Date: |
Feb 09, 2010, 211 days ago |
| Message: |
a test case, create table and insert statements for your example to work with should be appreciated.
Regards
Michel
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: Convert Rows into Columns |
| Author: |
dattatraya walgude, India |
| Date: |
Feb 09, 2010, 211 days ago |
| Message: |
Search Pivot on this forum
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=17682
Regards
Dattatraya |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here