如何把列转行(越简单越好)?
比如:
select max(time) from ....where ...
union
select min(time) from ....where ...
得到
2007-9-1
2007-9-2
希望得到:
2007-9-1 2007-9-2
[解决办法]
--如果where条件不同，甚至from都不同：
select
(select max(time) from ....where ...),
(select min(time) from ....where ...)
--例如
select
(select max(id) from sysobjects where xtype = 'x '),
(select min(id) from syscolumns where xtype = 175)
