sql - 如何求两个选择的总和

Question

我想在 SQL Server 中找到这两个选择的总和:

select count(rez1)*3 as Fit1 from Table_Name where rez1>rez2 

select count(rez1)*1 as Fit2 from Table_Name where rez1=rez2

Answer 1

您可以将 where 子句转换为 case 表达式并返回整数值，然后可以对这些值求和:

SELECT SUM (CASE WHEN rez1 > rez2 THEN 3
                 WHEN rez1 = rez2 THEN 1
            END)
FROM   table_name