oracle 字符串相等

[fenghaixu201]

请教大家，我想在ORACLE中直接把某个字段的重名数据查找出来，应该怎么写语句唉。

[abchappybear]

select fd FROM tb1 t WHERE t.ROWID > (SELECT MIN(t.ROWID) FROM tb1 t1
WHERE t1.fd= t.fd) group by fd having count(fd) >1;

[louisliu]

[Quote=引用 3 楼 abchappybear 的回复:]
select fd FROM tb1 t WHERE t.ROWID > (SELECT MIN(t.ROWID) FROM tb1 t1
WHERE t1.fd= t.fd) group by fd having count(fd) >1;
[/Quote]

请问后续的having子句的意义？？？

[arsenal1999]

用group 分组查询就可以了,查询个数大于1的

[wizard1]

比如说name字段 就这样吧
select name,count(*) from table group by name having count(*)>1

[ehsgs]

以name为例子
select * FROM test E
WHERE E.ROWID > (SELECT MIN(X.ROWID)
FROM test X
WHERE X.name = E.name);

[8193102]

2,3楼的都不错,都能解决问题,看往哪方面想的了