SQL Query Syntax help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Team,

Can you please help me in writing the syntax for the below mentioned table.

Input : 
ID Col A Col B Col C Col D Col E Col F
1111 aaaa bbbb cccc dddd eeee ffff
2222 bbbb cccc dddd eeee ffff aaaa
3333 cccc dddd eeee ffff aaaa bbbb
4444 dddd eeee ffff aaaa bbbb cccc
5555 eeee ffff aaaa bbbb cccc dddd
6666 ffff aaaa bbbb cccc dddd eeee
7777 cccc dddd eeee ffff aaaa bbbb
8888 dddd eeee ffff aaaa bbbb cccc
9999 ffff aaaa bbbb cccc dddd eeee
 
Required Output :
ID Col Name Col Value
1111 Col A aaaa
1111 Col B bbbb
1111 Col C cccc
1111 Col D dddd
1111 Col E eeee
1111 Col F ffff
2222 Col A bbbb
2222 Col B cccc
2222 Col C dddd
2222 Col D eeee
2222 Col E ffff
2222 Col F aaaa
3333 Col A cccc
3333 Col B dddd
3333 Col C eeee
3333 Col D ffff
3333 Col E aaaa
3333 Col F bbbb

And so on for the 4444, 5555, 6666, 7777, 8888, 9999


Thanks,
Srikanth B

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux