CODEWITHSUNDEEP
sql-serversql-server-2008sql-server-2012
Kamlesh
Kamlesh

Reputation: 386

Summary Query in SQL Server

I have following data

ID                                    Status
5bcb5961-20e-41b7-8af0-87ffe127830c   1
140c7f17-dba5-4bc8-1fb-062d1325c399   5
5bcb5961-20e-41b7-8af0-87ffe127830c   5
5bcb5961-20e-41b7-8af0-87ffe127830c   0

I want an output in summary form.

ID                                     Status_1  Status_5   Status_0
5bcb5961-d20e-41b7-8af0-87ffe127830c   1         1          1
140c7f17-dba5-4bc8-b1fb-062d1325c399   0         1          0

Can I get query for this output?

Upvotes: 2

Views: 77

Answers (1)

Devart
Devart

Reputation: 121902

SELECT
      ID
    , Status_1 = COUNT(CASE WHEN [Status] = 1 THEN 1 END)
    , Status_5 = COUNT(CASE WHEN [Status] = 5 THEN 1 END)
    , Status_0 = COUNT(CASE WHEN [Status] = 0 THEN 1 END)
FROM tbl
GROUP BY ID

Upvotes: 3

Related Questions