i have one table like
| col_1 | col_2 | col_3 | col_4 |
| aa | dd | gg | jj |
| bb | ee | hh | kk |
| cc | ff | ii | ll |
but i want the result as
| Column1 | Column2 | Column3 | Column4 |
| col_1 | col_2 | col_3 | col_4 |
| aa | dd | gg | null |
| bb | ee | hh | null |
| cc | ff | ii | null |
| dd | gg | jj | null |
| ee | hh | kk | null |
| ff | ii | ll | null |
| gg | jj | null | null |
| hh | kk | null | null |
| ii | ll | null | null |
| jj | null | null | null |
| kk | null | null | null |
| ll | null | null | null |
please any one can answer to this .
Nishant MittalPosted May 18, 2016, 10:32 AM