All Forums Database
ramjasmeenakshi 19 posts Joined 04/11
21 Oct 2015
Rows to columns query

Hi,
My table looks like
column name sort 
RAM    A   1
RAM    B    2
SHAM  C    NULL
DHAM  D    5
KIRU   E      6
MALA   F     7
MALA   G     8
Now i wan results like
column name sort  superscript 
RAM    A   1     1,2 
RAM    B    2     
SHAM  C    NULL  
DHAM  D    5      3
KIRU   E      6     4
MALA   F     7      5,6
MALA   G     8      

Meenakshi Swami
Tags:
ramjasmeenakshi 19 posts Joined 04/11
22 Oct 2015

Any suggestions??

Meenakshi Swami

VandeBergB 182 posts Joined 09/06
23 Oct 2015

it would help if your data made sense.  For example, in your desired results, you have RAM A 1 1,2 where does the 2 in the last column come from?  there isn't another RAM A row in your sample data.  please clarify.

Some drink from the fountain of knowledge, others just gargle.

You must sign in to leave a comment.