Alternative to COUNTIF in SQL Server

b09cbbtk 于 2023-03-11 发布在 SQL Server

关注(0)|答案(1)|浏览(180)

I used COUNTIF on SQL Server to COUNT a particular value with condition but it brought out an error.

SELECT 
    total rounds, total member, total customer,
    ROUND(total rounds/total member, 2) * 100 AS memberper
FROM 
    (SELECT 
         COUNT(rideid) total rounds
         COUNTIF(member_customer = 'member') AS total member,
         COUNTIF(member_customer = 'customer') AS total customer
     FROM 
         Data)

sql-server

来源：https://stackoverflow.com/questions/75692706/alternative-to-countif-in-sql-server

1条答案

按热度按时间

1zmg4dgp1#

add comma

COUNT(rideid) as  total rounds,    << Comma , as

Example COUNTIF in SQL

Excel: =COUNTIF(Ax:Ay, 42)
SQL: COUNT(CASE WHEN A = 42 THEN 1 END)

Recheck column name total rounds, total member, total customer

SELECT 
    total rounds, total member, total customer,  << Wrong name [total_member, total_customer]?
    ROUND(total rounds/total member, 2) * 100 AS memberper
FROM 

AND

COUNT(rideid) total rounds
COUNTIF(member_customer = 'member') AS total member,
COUNTIF(member_customer = 'customer') AS total customer

You need to double-check all of the SQL queries again.

赞(0）回复(0）举报 2023-03-11

我来回答

Alternative to COUNTIF in SQL Server

1条答案

相关问题

热门标签

最新问答