从MySQL表的同一列中获取计数? [英] getting count from the same column in a mysql table?
本文介绍了从MySQL表的同一列中获取计数?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
例如,我想对同一字段进行计数以获取不同的值:
I wanted to a count of the same field for different values for example:
用户{user_id,性别}
user{user_id, gender}
性别显然可以是男性或女性:)
Gender can have obviously male or female :)
我想获得所有男性和女性的计数,即
i want to get count for all the males and females i.e.
COUNT(male) COUNT(female)
4 16
但是我很困惑,因为它们来自相同的gender coloumn
谢谢
but im confused because they come from the same gender coloumn
thanks
推荐答案
尝试此操作以获得行结果:
Try this for row wise result:
SELECT gender, COUNT(User_id) AS count
FROM User
GROUP BY gender;
输出:
| gender | count |
|--------|-------|
| F | 4 |
| M | 2 |
尝试此操作以获得总计的行明智结果:
Try this for row wise result with grand total:
SELECT (IFNull(gender,'Total')) AS gender,
COUNT(User_id) AS Count
FROM User
GROUP BY gender
WITH rollup;
输出:
| gender | Count |
|--------|-------|
| F | 4 |
| M | 2 |
| Total | 6 |
尝试此操作以获得列明智的结果:
Try this for column wise result:
SELECT
COUNT(CASE WHEN gender = 'M' THEN User_id END) AS males,
COUNT(CASE WHEN gender = 'F' THEN User_id END) AS females,
COUNT(*) AS Total
FROM User;
输出:
| males | females | Total |
|-------|---------|-------|
| 2 | 4 | 6 |
这篇关于从MySQL表的同一列中获取计数?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文