Hi experts,
FOr example if I have Table1 with 3 rows:
Number Name
1 John
2 Mary
3 Sam
How can I code a Select to get the ouput as:
John Mary Sam each name in its own column?
Would a Pivot do that? Can anyone give the sql syntax please?
Thanks