分别显示每个列中每个类别的总数——SQL

Question

哪里有像

这样的数据库

<表类>性别ssc_btbody><<tr>F中部F中部F其他中部其他

SELECT gender as key, count(*) as value
FROM <table>
GROUP BY gender
UNION ALL
SELECT ssc_b as key, count(*) as value
FROM <table>
GROUP BY ssc_b

正如你所问的，答案是

select a.gender, a.s, b.gender, b.s from 
(select ROW_NUMBER() OVER() AS num_row, gender, sum(num_gender) s from t group by gender) a 
outer join 
(select ROW_NUMBER() OVER() AS num_row, ssc_b, sum(num_ssc_b) s from t group by ssc_b) b 
on a.num_row=b.num_row

但也许更合乎逻辑的是将上面的内部查询作为两个单独的查询。