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
可能因为工作的原因 接触数据库这块比较少，之前都是做程序这块，数据库这块都有专门的人来做 分工都很明细 所以对数据库这一块完全不了解。前段时间 去面试了几家公司 几乎都是在数据库这块挂掉的 连个简单的SQ ......
