Ta老师题库
有一个表 table1 有两个字段 FID，Fn
22 查阅
参考答案:
正确答案：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)