来源:蜘蛛抓取(WebSpider)
时间:2017-06-28 09:08
标签:
数据缺失值处理
写出sql语句,获取同一表中员工重名的信息(没有跟其他表关联) - ITeye问答
如有一张employer表,表中每条记录用id标识,姓名是可重复的,现在是查询出本表中有哪些重名的记录???
问题补充:hudingchen 写道什么数据库?
mySql 数据库
问题补充:hudingchen 写道
FROM employer
WHERE name IN (SELECT name
FROM employer
GROUP BY name
HAVING COUNT(*) & 1)
子查询SELECT name FROM employer GROUP BY name& HAVING COUNT(*) & 1 是正确的,但 加上外层查询就出错了,这是为什么呢??
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
问题补充:hudingchen 写道
FROM employer
WHERE name IN (SELECT name
FROM employer
GROUP BY name
HAVING COUNT(*) & 1)
hudingchen 写道
FROM employer
WHERE name IN (SELECT name
FROM employer
GROUP BY name
HAVING COUNT(*) & 1)
刚才是我写错了, 我是这么写的:
&&& SELECT * from employee where ename in (SELECT ename,count(ename) FROM employee& GROUP BY ename HAVING COUNT(*) &1)
& 子查询中多了个count(ename)当然不对啊!!
& 谢谢高手!!
采纳的答案
FROM employer
WHERE name IN (SELECT name
FROM employer
GROUP BY name
HAVING COUNT(*) & 1)
http://wangjinlongaisong-126-/blog/1455812我博客中有对查询的基本操作
Select Name,Count(*) From employer Group By Name Having Count(*) & 1
employer表,比方说
在employer表中存在一个字段“name”,
而且不同记录之间的“name”值有可能会相同,
现在就是需要查询出在该表中的各记录之间,“name”值存在重复的项;
Select Name,Count(*) From employer Group By Name Having Count(*) & 1
什么数据库?
已解决问题
未解决问题