leetcode 182 使用having令group by少一层

看到此题，一瞬间就完事了啊，直接一个group by再嵌套一层完事。

# Write your MySQL query statement below
select
    Email
from
    (select
        Email, count(Email) as ct
    from
        person
    group by
        Email
    ) db0
where
    ct > 1

但其实这一层是可以不必要的，使用having条件即可，这是专属于group by的操作，可以方便少一层select

# Write your MySQL query statement below
select
    Email
from
    person
group by
    Email
having
    count(*) > 1