表为
fav0 fav1 fav2 ..... favN
1 1 1 1
1 1 1 0统计每一列大于1的个数如果折开sql就是
SELECT COUNT(*) FROM info WHERE fav0 > 0
...
SELECT COUNT(*) FROM info WHERE favN > 0 输出结果为
fav0 fav1 fav2 .... favN (列名)
2 2 2 1 (大于1的个数)
fav0 fav1 fav2 ..... favN
1 1 1 1
1 1 1 0统计每一列大于1的个数如果折开sql就是
SELECT COUNT(*) FROM info WHERE fav0 > 0
...
SELECT COUNT(*) FROM info WHERE favN > 0 输出结果为
fav0 fav1 fav2 .... favN (列名)
2 2 2 1 (大于1的个数)
(SELECT COUNT(*)FROM TB WHERE fav0>0)AS fav0,
(SELECT COUNT(*)FROM TB WHERE fav0>0)AS fav0,
(SELECT COUNT(*)FROM TB WHERE fav0>0)AS fav0,
(SELECT COUNT(*)FROM TB WHERE fav0>0)AS fav0,
(SELECT COUNT(*)FROM TB WHERE fav0>0)AS fav0
sum(case when fav0>0 then 1 else 0 end) as fav0,
sum(case when fav1>0 then 1 else 0 end) as fav1,
..........
from
tb
(SELECT COUNT(*)FROM TB WHERE fav0>0)AS fav0,
(SELECT COUNT(*)FROM TB WHERE fav0>0)AS fav0,
(SELECT COUNT(*)FROM TB WHERE fav0>0)AS fav0,
(SELECT COUNT(*)FROM TB WHERE fav0>0)AS fav0,
(SELECT COUNT(*)FROM TB WHERE fav0>0)AS fav0
对的