SQL 两个子查询的 MAX 值

Question

我有两个查询，我想获取其中两个查询的最大值。

  MAX((SELECT COUNT(p.[ItemID]) FROM [dbo].[Table] p WHERE HasHuman=0),
      (SELECT COUNT(p.[ItemID]) FROM [dbo].[Table] p WHERE HasHuman=1))

Answer 1

您可以在单个查询中计算这两个结果，然后应用 TOP:

select top 1 
   HasHuman,
   COUNT(p.[ItemID]) as cnt
from [dbo].[Table]
group by HasHuman 
order by cnt desc