17,377
社区成员
发帖
与我相关
我的任务
分享
select round(avg(s.paravalue), 5) paravalue, s.assaytime
from (select a.paratype, a.paravalue,
from test a
where a.paratype = '123'
and rownum < 3
order by a.time) s
group by s.paratype
union
select round(avg(s.paravalue), 5) paravalue, s.assaytime
from (select a.paratype, a.paravalue
from test a
where a.paratype = '321'
and rownum < 3
order by a.time) s
group by s.paratype
select round(avg(s.paravalue), 5) paravalue,
min(s.time), s.paratype
from(
select a.paratype, a.paravalue, a.time,
row_number() over(partition by a.paratype order by a.time) rn
from test a where a.paratype in ('123','321')
)s where s.rn <3 group by s.paratype