I have a normal table:
id |value
12 |1
24 |3
35 |20
..and so on to id lets say 100. I wonder if there's a query to select all, but split the column into 3 equally-separated columns and numerate the 1st from 1 to 33, 2nd 34-66, 67-100 (or anything close to that logic)
expected output: I don't care about the ids so what need is something like
order1|value1 order2|value2 order3|value3
1 |1 34|80 67|206
2 |4 35|100 68|207
3 |6 36|102 69|280
... .... ...
33|60 66|201 100|810