SQLTeam.com | Weblogs | Forums

How to get sql output in the query mentioned


#1

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?

Thanks


Sql output from two columns
#2