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

Filed under:
|
|

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

Related posts about sql

Related posts about mysql