|
Posted by Zvonko on 05/29/06 12:31
Hi all!
I was wondering if this is possible:
To make things simpler, I have a table:
CREATE TABLE example
(text VARCHAR(30),
number INTEGER);
For example I have this values in it:
someText 4
someText1 6
someText2 8
Now I would like to get a ResultSet using only SQL in which I would like
to have someText in four rows, someText2 in 6 rows and someText2 in 8 rows.
Basically to get field text repeated for number of times.
ResukltSet:
someText
someText
someText
someText
someText1
someText1
someText1
someText1
someText1
someText1
someText2
someText2
someText2
someText2
someText2
someText2
someText2
someText2
Please help.
Navigation:
[Reply to this message]
|