Q. Write a query to duplicate each row based on the value in the repeat column? The input table data looks like as below Products, Repeat
A, 3
B, 5
C, 2
Now in the output data, the product A should be repeated 3 times, B should be repeated 5 times and C should be repeated 2 times. The output will look like as below