MYSQL ²éÕÒ³öÖظ´ÁÐÖµ - MS-SQL Server / ÒÉÄÑÎÊÌâ

DB: MySql

Problem:

create table aaa(
  id int primary key,
  phone varchar(100),
  name varchar(50)
)

insert into aaa values(000101,'111','jackie');
insert into aaa values(000102,'222','milk');
insert into aaa values(000103,'111','lucy');
insert into aaa values(000104,'111','mechelle');
insert into aaa values(000105,'222','tom');
insert into aaa values(000106,'333','roy');

²éÕÒ³öphoneÁÐÓÐÖظ´µÄÖµ£¬¼´count(phone)>=2µÄÖµÁгöÀ´

Required Result:
phone num
111 3
222 2

Çë¸ßÊÖ½â´ð£¬ÔÚÏߵȣ¬Ð»Ð»

---

SQL code:
select phone,
count(*)num
from aaa
group by phone
having count(*)>=2

---

SQL code:
create table aaa(
id int primary key,
phone varchar(100),
name varchar(50)
)

insert into aaa values(000101,'111','jackie');
insert into aaa values(000102,'222','milk');
insert into aaa values(000103,'111','lucy');
insert into aaa values(000104,'111','mechelle');
insert into aaa values(000105,'222','tom');
insert into aaa values(000106,'333','roy');
select phone,
count(*)num
from aaa
group by phone
having count(*)>=2
drop table aaa
/*
phone