怎样查询相同数据？

[GameOfLife]

比如，表（tblName）结构如下：

id fileId
1 1
2 2
3 2
4 3
5 3

怎么取出表中，fileId出现相同的所有记录，请高手们帮帮忙，先谢了！

[cpp2017]

select * from tbname
where fieldid in(select fieldid from tbllname group by fieldid having count(*) >1)

[EthanWong]

select * from tblName where fileId (select fileId from (select fileId,c=count(*) from tblName group by fileId) tbl where tbl.c>1)

[EthanWong]

上面漏写了：

select * from tblName where fileId in (select fileId from (select fileId,c=count(*) from tblName group by fileId) tbl where tbl.c>1)

[GameOfLife]

非常感谢，楼上2位的解答。

[wbpwbpwbp]

kankan