Repeat a result row multiple times by value in row

Question

i have a question about sql query. i want to duplicate a one row with same value, The number of lines must be same with the value of quantity

example i have 1 data like this

Item  ItemName   Quantity
B100  Mouse      10

but i want to be like this

Item  ItemName   Quantity
B100  Mouse      10
B100  Mouse      10
B100  Mouse      10
B100  Mouse      10
B100  Mouse      10
B100  Mouse      10
B100  Mouse      10
B100  Mouse      10
B100  Mouse      10
B100  Mouse      10

can you help me

Thanks Before

score 3 · Accepted Answer · edited May 23 '17 at 11:53

3

Create a numbers table and just do a CROSS JOIN with it

select Item , ItemName ,  Quantity
from yourtable A
cross join (select num from numbers) b
where a.Quantity <= b.num

To generate sequential numbers in Mysql check the below answers

edited May 23 '17 at 11:53

Community

1
1

answered Dec 13 '15 at 16:36

Pரதீப்

91,748
19
131
172

Thankyou, very usefull But i think where condition shoul be "where a.Quantity >= b.num" – derry susilo Dec 14 '15 at 06:56

Repeat a result row multiple times by value in row

1 Answers1

Linked