Need output in sql server -


i have input below here having 2 columns..one target , 1 reference...here target may have 1 or more references need show in 1 table

table

col1    col2        b        c        d e        f 

expected result

col1    col2        b        c        d b        c        d        e        f f        e 

try this:

select col1, col2 tbl union select col2, col1 tbl 

Comments

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -