读书人

sql怎么把结果放到一行里面去

发布时间: 2012-02-22 19:36:55 作者: rapoo

sql如何把结果放到一行里面去
select 'a ' as a
select 'b ' as b
如何得到
[a][b]
a b
就是把结果放到一行里面去


[解决办法]

select * from
(select 'a ' as a )a
CROSS join
(select 'b ' as b)b

读书人网 >SQL Server

热点推荐