SQL Countif函数

发布时间：2020-12-12 08:48:31 所属栏目：MsSql教程来源：网络整理

导读：这个问题在这里已经有一个答案： Sql Server equivalent of a COUNTIF aggregate function6 我有一张桌子,如下所示 Type of Station | Broadcast Management----------------+-------------------------Full Power | Sinclair Broadcast GroupFull Power | Si

这个问题在这里已经有一个答案：> Sql Server equivalent of a COUNTIF aggregate function6
我有一张桌子,如下所示

Type of Station | Broadcast Management
----------------+-------------------------
Full Power      | Sinclair Broadcast Group
Full Power      | Sinclair Broadcast Group
LPTV cable      | Sinclair Broadcast Group
LPTV no cable   | Sinclair Broadcast Group

现在我想执行一个查询,结果将会如下所示

Broadcast Management       | Full Power | LPTV cable | LPTV no cable
---------------------------+------------+------------+--------------
Sinclair Broadcast Group   |  2         |     1      |  1

任何人都可以帮助我如何写这个查询

解决方法

没有单个SUMIF或COUNTIF.

但您确实有SUMOR COUNT和IF使用CASE …

SELECT
  [Broadcast Management],SUM(CASE WHEN [Type of Station] = 'Full Power'    THEN 1 ELSE 0 END)   AS [Full Power],SUM(CASE WHEN [Type of Station] = 'LPTV Cable'    THEN 1 ELSE 0 END)   AS [LPTV Cable],SUM(CASE WHEN [Type of Station] = 'LPTV No Cable' THEN 1 ELSE 0 END)   AS [LPTV No Cable]
FROM
  yourTable
GROUP BY
  [Broadcast Management]

对于计数,您可以使ELSE返回NULL,因为计数为1,2,4,NULL为3.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!