SQLTeam.com | Weblogs | Forums

How to get sql output in the query mentioned

if data in two columns is something like

Emp Dep
1 A
2 B
c 3
4 D

in sql output i want 1 2 3 4 in Emp and a b c d in dep.

pleaselet me know how towrite query to get output?