SQL algorithm question to convert a table
Posted
by every_answer_gets_a_point
on Stack Overflow
See other posts from Stack Overflow
or by every_answer_gets_a_point
Published on 2010-05-12T23:10:38Z
Indexed on
2010/05/12
23:14 UTC
Read the original article
Hit count: 127
i have a table like this:
1 x y
2 a
3 b
4 c d e
i want to use a sql statement to turn it into this:
1 x
1 y
2 a
3 b
4 c
4 d
4 e
i am having trouble building the sql statement. please help!
© Stack Overflow or respective owner