注意having语句是group分组时候的筛选语句
select t.title, count(*) t
from titles t
group by title
having count(*) >= 2 # hanging 语句是分组之后的筛选条件
注意having语句是group分组时候的筛选语句
select t.title, count(*) t
from titles t
group by title
having count(*) >= 2 # hanging 语句是分组之后的筛选条件