每一列有COUNT个值? [英] COUNT of each value at one column ?

问题描述

我有2列的表(name，value)，value可以是(0,1，null)，
我想按名称选择(名称，值的计数= 0，值的计数= 1，值的计数= null)按名称分组，我该怎么做? 谢谢..

i have table with 2 column ( name , value ) , value can be ( 0,1,null ),
i want to select (name , count of value = 0 , count of value = 1 , count of value = null ) group by name , how can i do that ??
thanks ..

推荐答案

您已经说过，可以使用GROUP BY子句.例如:
SELECT名称，值，COUNT(*)
从...
GROUP BY名称，值

问候，

mika

AS you already said yourself, you can use GROUP BY clause for that. For example:
SELECT Name, Value, COUNT(*)
FROM ...
GROUP BY Name, Value

Regards,

mika

您要使用PIVOT查询:

You want a PIVOT query :

SELECT *
FROM (
SELECT name,
            CASE value 
            WHEN NULL THEN ''no value''
            WHEN 0 THEN ''zero''
            WHEN 1 THEN ''one''
            END AS thevalue
 FROM [yourDB].[youruser].[yourTable]) AS datatable
 PIVOT
( COUNT(thevalue)
  FOR thevalue IN ([no value],[zero],[one])
) AS myquery

这样的事情.

干杯

Something like that.

Cheers

SELECT        Districts.name, COUNT(DISTINCT Interview_Schedule.app_id) AS [APP] ,                                                                         (COUNT(Interview_Schedule.value)FROM            Districts INNER JOIN
                         Interview_Schedule ON Districts.id = Interview_Schedule.interview_district WHERE Interview_Schedule.value=1)AS [ONES],
(COUNT(Interview_Schedule.value)FROM            Districts INNER JOIN
                         Interview_Schedule ON Districts.id = Interview_Schedule.interview_district WHERE Interview_Schedule.value=0)AS [ZEROS],
(COUNT(Interview_Schedule.value)FROM            Districts INNER JOIN
                         Interview_Schedule ON Districts.id = Interview_Schedule.interview_district WHERE Interview_Schedule.value IS NULL)AS [NULLS]
FROM            Districts INNER JOIN
                         Interview_Schedule ON Districts.id = Interview_Schedule.interview_district
WHERE        (Interview_Schedule.work_flow_id = 2)
GROUP BY Districts.name

这篇关于每一列有COUNT个值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！