Select
AVG(a) as a,
AVG(b) as b
from tt
having AVG(a)>0 and AVG(a)<3 and AVG(b)<3 and AVG(b)>1目前是求的是在范围内的平均数,然后,想把这些求出的值做个统计,要怎么写?
AVG(a) as a,
AVG(b) as b
from tt
having AVG(a)>0 and AVG(a)<3 and AVG(b)<3 and AVG(b)>1目前是求的是在范围内的平均数,然后,想把这些求出的值做个统计,要怎么写?
Select
AVG(a) as a,
AVG(b) as b
from tt
GROUP BY [name]
having AVG(a)>0 and AVG(a)<3 and AVG(b)<3 and AVG(b)>1
select AVG(a) as a,
AVG(b) as b from
(Select
AVG(a) as a,
AVG(b) as b
from tt
GROUP BY [name]
having AVG(a)>0 and AVG(a)<3 and AVG(b)<3 and AVG(b)>1) a嵌套下不就行了么?
select avg(a) as a, avg(b) as b
from
(
Select
AVG(a) as a,
AVG(b) as b
from tt
having AVG(a)>0 and AVG(a)<3 and AVG(b)<3 and AVG(b)>1
) T--#2.
select
a,
b,
Alla = avg(a) over(),
Allb = avg(b) over()
from
(
Select
AVG(a) as a,
AVG(b) as b
from tt
having AVG(a)>0 and AVG(a)<3 and AVG(b)<3 and AVG(b)>1
) t