Table Name - 'Sample'
Test
--------
INR
1,2,3
4,5
PVR
6,7
Question : How to split this a single columns data into two columns!
Expected Output :
A B
---------
INR 1
INR 2
INR 3
INR 4
INR 5
PVR 6
PVR 7
I don't know how to solve this kind of questions. I tried in some other different way and got unexpected Output.(I know this may look illogical)
Select I. Test as A, J.Test as B
from Sample I, Sample J
where J. Test = I. Test;
Can anyone help me regarding this!