How to convert rows to columns

Question

Table values:

EMP_NO EMP_NAME                     
-------------- 
    14 admin                          
     1 ram                            
     2 mohan                          
     3 mallu                          
     4 scoot                          
     5 jim                            
     6 ravi                           
     7 manju                          
     8 manoj                          
     9 sarath                         
    10 hemanth

how to convert rows to columns?

@armunin its not duplicate of that post as user asking for pivot — Indranil.Bharambe, Dec 02 '13 at 12:03
@ram sql and oracle has different ways to pivot thats why i asked. anyways i provide oracle solution — Indranil.Bharambe, Dec 02 '13 at 12:05

Indranil.Bharambe · Accepted Answer · 2013-12-02T12:09:36.450

0

try following query for oracle

select 
   emp_no,
   rtrim (xmlagg (xmlelement (e, emp_name || ',')).extract ('//text()'), ',') enames
from 
   emp
group by 
   emp_no
;

for sql server try

SELECT *
FROM (
    SELECT 
       emp_name 
    FROM tblemployee
) as s
PIVOT
(
    min(emp_id)
    FOR emp_id
)AS pivot

edited Dec 02 '13 at 12:09

answered Dec 02 '13 at 12:00

Indranil.Bharambe

1,462
3
14
25

how to use PIVOT for this case? – ram12393 Dec 02 '13 at 12:03
1

As far as I know there is a `PIVOT`-function in Oracle as well. Maybe [this](http://www.oracle-base.com/articles/11g/pivot-and-unpivot-operators-11gr1.php) helps. – Armunin Dec 02 '13 at 12:23
@Armunin in ur reference link there **PIVOT (SUM(quantity) AS sum_quantity FOR (product_code) IN ('A' AS a, 'B' AS b, 'C' AS c));** how to is SUM for my case? – ram12393 Dec 02 '13 at 12:27
I haven't worked with `PIVOT` so far, just wanted to give some more information – Armunin Dec 02 '13 at 12:40
+1 for me and armunin too :) – Indranil.Bharambe Dec 02 '13 at 12:42

How to convert rows to columns

1 Answers1