sql多SQL查询结果合并显示

1、多个查询结果按行显示

select  max(Objectid)  as Objectid  from   [tableName] union all
select  min(Objectid)  as Objectid  from  [tableName];

查询结果如下
如果觉得查出来的结果区分不开，可以在前面加上区分字段，代码如下：

select  'Objectid1',max(Objectid)  as Objectid  from   [tableName] union all
select 'Objectid2', min(Objectid)  as Objectid  from  [tableName];

查询结果如下：

这里需提醒的是用union all连接的sql语句select查询后跟的查询内容个数需保持一致

2、多个查询结果按列并列显示
写法一：

select  
(select    max(Objectid)    from   [tableName]) as Objectid1 ,
(select  min(Objectid)    from   [tableName])  as Objectid2;  

查询结果展示如下：

写法二：

select bsm1,bsm2 from (
(select 1 id, max(Objectid)  as Objectid1  from   [tableName]) X  left join
(select 1 id, min(Objectid)  as Objectid2  from   [tableName]) Y  on X.id=Y.id)

写法二使用的left join，结果与写法一一样。

注：以上拼接的两个sql语句只是示例