有一个表 table1 有两个字段 FID,Fn
26 查阅
参考答案:
正确答案:select * from table1 where FID in (select FID from table1 group by FID having (count(Distinct Fno))>=2)
参考答案:
正确答案:select * from table1 where FID in (select FID from table1 group by FID having (count(Distinct Fno))>=2)