SQL Server Combine 2 different queries with different columns

mjqavswn 于 2023-05-16 发布在其他

关注(0)|答案(2)|浏览(159)

How can I combine the 2 queries below in order to have the result in the same table as 4 columns Table name, last create date, last update date and columns count?

select distinct 
    'abc.gcc_case' Table, 
    max(create_date) as Last_Create_Date, 
    max(update_date) as Last_Update_Date 
from abc.gcc_case

select 
    count(*) as Columns_Count 
from information_schema.columns
where Table_name = 'gcc_case'

I was trying to use a join but I am not sure what to use to give the result I was looking for.

sql-server

来源：https://stackoverflow.com/questions/76205030/combine-2-different-queries-with-different-columns

2条答案

按热度按时间

kkbh8khc1#

Here is an option

The distinct is redundant

select 'abc.gcc_case' Table
         ,max(create_date) as Last_Create_Date
         ,MAX(update_date) as Last_Update_Date 
         ,(select count(*) as Columns_Count 
            from information_schema.columns
           where Table_name = 'gcc_case'
          ) as column_count
     from abc.gcc_case

赞(0）回复(0）举报 2023-05-16

jv4diomz2#

Something I noticed is that you want the output of these two queries to be in the a row

select * 
from  (

             select distinct 
                'abc.gcc_case' TableTableName, 
                max(create_date) as Last_Create_Date, 
                MAX(update_date) as Last_Update_Date 
            from abc.gcc_case
)List
cross apply (  
               select 
                    count(*) as Columns_Count 
                from information_schema.columns
                where Table_name = 'gcc_case'
        )cot

result:

TableName	Last_Create_Date	Last_Update_Date	Columns_Count
abc.gcc_case	2020-02-01	2020-02-01	10

赞(0）回复(0）举报 2023-05-16

我来回答

SQL Server Combine 2 different queries with different columns

2条答案

相关问题

热门标签

最新问答