azure - 合并结果 Cosmosdb 中的两个查询

Question

SELECT 
count(c.Transaction_Id) as Legacy FROM c where c.OverallStatus = 'COMPLETED' and c.KeyData2 like 'WLS_%'
and contains (c.Created_Date, '2021-08-11') and c.Transaction_Set_Code = '210'

SELECT 
count(c.Transaction_Id) as NonLegacy FROM c where c.OverallStatus = 'COMPLETED' and c.KeyData2 not like 'WLS_%'
and contains (c.Created_Date, '2021-08-11') and c.Transaction_Set_Code = '210'

必填答案：

[
    {
        "Legacy": 18753,
        "NonLegacy": 121862
    }
]

标签： azureazure-cosmosdbazure-cosmosdb-sqlapi

Answer 1

Select t.cnt , t.keyd from (
  SELECT count(1) as cnt, c.keydata2 as keyd 
  FROM c 
  where c.OverallStatus = 'COMPLETED' 
  and contains (c.Created_Date, '2021-08-11')
  and c.Transaction_Set_Code = '210'
  group by c.KeyData2)
t
 where t.keyd like 'wls_%' or t.keyd not like 'wls_%'