计算唯一值的数量

2021-11-20 00:00:00 mysql

如果我有三列:

orderNumber, name, email

我想计算表格中有多少独特的电子邮件，我该怎么做?

and I would like to count how many unique emails are in the table how would I go about doing so?

这样的声明:

SELECT count(email) FROM orders

给我总数.

我试过SELECT DISTINCT count(email) FROM orders

但这似乎并没有给我我期望的数字.

but that does not seem to be giving me the numbers I am expecting.

推荐答案

使用

SELECT count( DISTINCT(email) ) FROM orders

Distinct 提供唯一的电子邮件 ID，然后简单地对其进行计数.

Distinct provide unique email ids and then simply count them.

相关文章