I don't know how to even google the answer to this. I am in bit of need for some assistance.
I have data that looks like this:
SELECT COL1,COL2,COL3 FROM TABLE
Results:
Cat 1 brown
Cat 2 blue
Cat 3 purple
Dog 1 black
mouse 1 blue
mouse 2 yellow
mouse 3 red
mouse 4 green
I need my result set to add data until the increment equals 5 as shown below:
Cat 1 brown
Cat 2 blue
Cat 3 purple
Cat 4 NULL
Cat 5 NULL
Dog 1 black
Dog 2 NULL
Dog 3 NULL
Dog 4 NULL
Dog 5 NULL
mouse 1 blue
mouse 2 yellow
mouse 3 red
mouse 4 green
mouse 5 NULL
Any assistance would be helpful, this is my first post.