Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table like this
name | a_col sum | a_col count | b_col sum | b_col |
20541 | 46 | 68560 | 149 | |
a | 3141 | 9 | 2139 | 6 |
b | 8400 | 21 | 10846 | 29 |
c | 9000 | 16 | 55575 | 114 |
now i want this table like this
name trans count sum
a reserved a_col 9 68560
b_col 6 2139
here i want to add reserved in value list like i want to create dummy one same goes for count and sum
.. not be suppose to come from table
so how i structure of modify table like above ?