从MySQL表的同一列中获取计数? [英] getting count from the same column in a mysql table?

问题描述

例如，我想对同一字段进行计数以获取不同的值:

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屋！