计算唯一值的数量

Count number of unique values(计算唯一值的数量)

问题描述

如果我有三列:

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.

这篇关于计算唯一值的数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！