How to convert rows into columns SQL

Question

I have rows called studentname and college. How can I convert this rows into columns with SQL?

Aakash Shah · Accepted Answer · 2018-07-10 15:29:38Z

1

I suppose you are trying a transpose operation..Let us consider this table for E.g:

TYPE DESCRIPTION

To convert it to columns you can use this query which uses TYPE column:

SELECT * FROM 
  ( 
    SELECT TYPE, DESCRIPTION
    FROM TRANSPOSE
  )
  PIVOT ( 
   COUNT(TYPE)
    FOR TYPE in ('1','2')
);

Note: PIVOT is supported only from Oracle 11g onwards.

Enjoy..

answered Jul 10, 2018 at 13:57

Aakash Shah

113 bronze badges

Sign up to request clarification or add additional context in comments.