Mo.Ashfaq Mo.Ashfaq - 2 years ago 88
SQL Question

How to count for a specific value column wise?

I have made the table with 4 columns using mysql.

Each column have datatype as


I have data like this:

ColA ColB ColC Cold
1 1 1 1
1 0 0 1
0 0 1 0

I wants to have query that will return the column name and no.of 1s it will have, like following:

ColA ColB ColC Cold
2 1 2 2

I have thinked about group by, aggregate function, but not able to design the query.

Any help would be appreciated

Answer Source

From your comment to AK47's answer, you may prefer

sum(colA) as colA, 
sum(colB) as colB, 
sum(colC) as colC, 
sum(colD) as cold -- I'm frozen
from Table1

See the diff in sqlFiddle

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download