Convert Row into columns

Question

how can I convert rows of my table as column value for eg I have a table a

emp id
1
2
3
4

and I want my output as

1   2   3   4

i am also using pivot in oracle and crosstab in postgres but not able to get desired solution as shown above.

"*not able to get desired solution*" is not an acceptable problem description. — , Dec 18 '13 at 08:11
Maybe this can help http://stackoverflow.com/questions/15491661/dynamic-pivot-in-oracle-sql or this http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:2648932900346131308 — A.B.Cade, Dec 18 '13 at 08:34
possible duplicate of [Oracle Rows to Column Transformation](http://stackoverflow.com/questions/9582218/oracle-rows-to-column-transformation) — John Doyle, Dec 18 '13 at 13:20

score 1 · Answer 1 · answered Dec 18 '13 at 08:27

1

Check the listagg function. Note you need at least Oracle 11 for this.

answered Dec 18 '13 at 08:27

Guntram Blohm

9,667
2
24
31

Postgres has `arrayagg`.. worth a mention! – ADTC Dec 18 '13 at 08:39

score 0 · Answer 2 · answered Dec 18 '13 at 08:15

0

Use this script and change it to your values to get desired results

    SELECT * FROM (SELECT emp_id, emp_points
    FROM   emp_data)
    PIVOT  (
                SUM(emp_points) AS sum_emp_points 
                FOR (emp_id) IN (1 AS [1], 2 AS [2],3 AS [3],4 AS [4])
           );

answered Dec 18 '13 at 08:15

Anoop

379
4
14

This doesn't look like a general solution, but specific to the data described in the question. It's better to make solutions that generally apply to similar situations without data type or length limits. – ADTC Dec 18 '13 at 08:24
I can provide specific answer only to a specific question with some clear explanation on data. – Anoop Dec 18 '13 at 09:02

score 0 · Answer 3 · answered Dec 18 '13 at 17:35

0

   select * from (select empno from t7) pivot(min(empno) for empno in (1,2,3,4));

answered Dec 18 '13 at 17:35

Sai

659
4
12
21

select * from (select emp_id from your_table) pivot(min(emp_id) for emp_id in (1,2,3,4)); – Sai Dec 18 '13 at 17:39

Convert Row into columns

3 Answers3