如何查找一个表里面有重复值的记录？

[djfu]

例如：一个学生表，
No Name Address
我要查询Address相同（籍贯：例如上海）的所有学生记录。

[HelloWorld_001]

select * from table
where Address in (
select Address from table
group by Address
having count(*)>1)

[dawugui]

例如：一个学生表，
No Name Address
我要查询Address相同（籍贯：例如上海）的所有学生记录。

select * from tb where address in (select address from tb group by address having count(*) > 1)