select * from table where Address in ( select Address from table group by Address having count(*)>1)
例如:一个学生表, No Name Address 我要查询Address相同(籍贯:例如上海)的所有学生记录。select * from tb where address in (select address from tb group by address having count(*) > 1)
where Address in (
select Address from table
group by Address
having count(*)>1)
No Name Address
我要查询Address相同(籍贯:例如上海)的所有学生记录。select * from tb where address in (select address from tb group by address having count(*) > 1)