一个面试题 ,请会SQL的高手帮下忙

发布网友 发布时间：2023-02-23 02:36

我来回答

共5个回答

热心网友 时间：2024-12-02 14:02

select max(FCLASS),FSCORE from table
where FCLASS in (select FCLASS,count(FID) from table having count(FID)>30 group by FCLASS)

热心网友 时间：2024-12-02 14:03

楼上的两条语句都无法运行，原因是FCLASS in (select FCLASS,count(FID) from table having count(FID)>30 group by FCLASS)，fclass是一个返回值，但是括号中的字段是两个，所以会执行不成功，有语法问题

select a.FCLASS,max(a.FSSCORE) from table a, (select FCLASS,count(FID)
from table
having count(FID)>30
group by FCLASS) b
where a.FCLASS=b.FCLASS
group by a.FCLASS

热心网友 时间：2024-12-02 14:03

帮muqiao520 补充一下,少了个group by. ^_^

select max(FCLASS),FSCORE
from
table
where
FCLASS in (select FCLASS,count(FID)
from table
having count(FID)>30
group by FCLASS)
group by FCLASS

热心网友 时间：2024-12-02 14:04

select FCLASS，FSSCORE from table where count(FID)>30 GOURP BY FSSCORE;

热心网友 时间：2024-12-02 14:05

Select FCLASS，Max(FSSCORE) From Table
Group By FCLASS Having Count(FID)>30

好像就这样就行了。