Posted - 06/06/2005 : 08:47:13
I have exported data from a dump file. I have to now convert into our schema.
I have following scenario which is stopping my conversion.
30003016WYSONG RTM 3016
The problem is I have to place all the col1 values starting with 1, 2, 3 and having same values of col2 (in
this case 3016, 3017) in single of row of new table.
I have tried using insert subquery with group by clause but it doesnt seem to solve the problem.
Any suggestions/insights would be helpful