Hello Friends,  Have you ever been in a situation where you as a developer knows that your data is stored in your table rows, but you would like to present the data as a column ?? There are many way to handle this situation. Here I am sharing few of them which I know.​ Below is the sample table and data : ------------------------------------------------------------ [sql]CREATE TABLE yr_table (         Roll_No            NUMBER,         Subject            VARCHAR2(20),         Marks              NUMBER ); [/sql] [sql]insert into yr_table VALUES (1212324,'MTH',90); insert into yr_table VALUES (1212324,'PHY',72); insert into yr_table VALUES (1212324,'CHE',85); insert into yr_table VALUES (1212324,'BIO',78); insert into yr_table VALUES (1212334,'MTH',85); insert into yr_table VALUES (1212334,'PHY',65); insert into yr_table VALUES (1212334,'CHE',74); insert into yr_table VALUES (1212672,'MTH',88); insert into yr_table VALUES (1212672,'PHY',42); insert into yr_table VALUES (1212672,'BIO',12); COMMIT; [/sql] ------------------------------------------------------------------- Now I would like to represent above data into below format : We can achieve above output  in different way. # Method 1 ->  Using DECODE  function [sql]SELECT  ROLL_NO,                  MAX( DECODE( SUBJECT , 'MTH' , MARKS ) ) AS MTH  ,                  MAX( DECODE( SUBJECT , 'PHY' , MARKS ) ) AS PHY ,                  MAX( DECODE( SUBJECT , 'CHE' , MARKS ) ) AS CHE ,                  MAX( DECODE( SUBJECT , 'BIO' ,  MARKS ) ) AS BIO FROM yr_table GROUP BY ROLL_NO ORDER BY 1  ;​ [/sql] To understand the above query, first see  the below output of above query without using MAX function then you can understand how above query works. # Method 2 -> Using CASE​ statement  [sql]SELECT    ROLL_NO,                 MAX( CASE WHEN SUBJECT = 'MTH' THEN MARKS END) MTH ,                 MAX( CASE WHEN SUBJECT = 'PHY' THEN MARKS END) PHY ,                 MAX( CASE WHEN SUBJECT = 'CHE' THEN MARKS END) CHE ,