UC知道如何用SQL检索出姓名相同，其他信息不同的所有记录（能在ACCESS上运行的）？
来源：百度知道 编辑：UC知道 时间：2024/06/05 19:50:46
比如表A：
SNAME AGE SEX MAJOR
liutao 25 boy computer
shi 23 girl SoftTest
malimei 26 girl manager
weixing 26 boy hardware
liutao 27 boy editor
jianxin 21 boy japanese
yanghao 26 boy spam
jianxin 23 girl searchquality
想要的结果是：
liutao 25 boy computer
liutao 27 boy editor
jianxin 21 boy japanese
jianxin 23 girl searchquality
SNAME AGE SEX MAJOR
liutao 25 boy computer
shi 23 girl SoftTest
malimei 26 girl manager
weixing 26 boy hardware
liutao 27 boy editor
jianxin 21 boy japanese
yanghao 26 boy spam
jianxin 23 girl searchquality
想要的结果是：
liutao 25 boy computer
liutao 27 boy editor
jianxin 21 boy japanese
jianxin 23 girl searchquality
select a.SNAME from A b,
(select SNAME from A group by SNAME having count(*)>1) a
where a.SNAME =b.SNAME
select A.sname,A.age,A.sex,A.major from A
right join (select sname from A group by sname having count(sname) > 1) B
on A.sname = B.sname
select * from a
where sname in (select max(sname) from A group by sname having count(sname)>1)
select * from A where SNAME like (select SNAME from A group by SNAME having(count(*)>1))
select * from A where sname='a' order by asc