数据库 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语句只是示例

评论可见，请评论后查看内容，谢谢！！！

您阅读本篇文章共花了：

金钥匙