是这样吗? select sum(instantData.value)/ (Sum ( Floor( Sum ( Floor( Case When "条件" Then 0 Else 1 end) + 1 ) from (select TERMINAL_CODE , MEASURE_NO , Sum(Case When ("条件") Then 0 Else 1 End ) value from instantData group by RMINAL_CODE , MEASURE_NO ) instantData , TERMINAL terminal , SCHEME scheme where scheme.BRAND_ID = terminal.BRAND_ID and instantData.TERMINAL_CODE = terminal.CODE And instantData.MEASURE_NO = scheme.MR_MEASURE_NO
select sum(instantData.value)/
(Sum ( Floor( Sum ( Floor( Case When "条件" Then 0 Else 1 end) + 1 )
from
(select TERMINAL_CODE ,
MEASURE_NO ,
Sum(Case When ("条件") Then 0 Else 1 End ) value
from instantData
group by RMINAL_CODE ,
MEASURE_NO ) instantData ,
TERMINAL terminal ,
SCHEME scheme
where scheme.BRAND_ID = terminal.BRAND_ID
and instantData.TERMINAL_CODE = terminal.CODE
And instantData.MEASURE_NO = scheme.MR_MEASURE_NO
这里多加一层括号试试
sum((select .... ))