首先创建一个用户表(user)创建表语句:
CREATE TABLE `user` (
`id` int(11) default NULL,
`username` varchar(100) default NULL,
`age` int(11) default NULL
)
插入表数据:
INSERT INTO `user` VALUES (1,'aa',1);
INSERT INTO `user` VALUES (2,'aa',2);
INSERT INTO `user` VALUES (3,'bb',3);
INSERT INTO `user` VALUES (4,'aa',2);
查找年龄为两岁,用户名字重复的用户记录sql:
select username ,count(*) from user where age=2 group by username having count(*)>1
显示结果图: