--1
select
median
(sales)
from
total_sales
--2
select
avg(sales)
from
(select
row_number()
over(order
by
sales)
as
rn,
name,
sales
from
total_sales)
t,
(select
count(*)
/
2
as
mid_c
from
total_sales)
b
where
rn
=
b.mid_c
or
rn
=
trunc
(b.mid_c+1)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024