oracle数据库sql窗口输入L键自动关闭整个数据库客户端，求高手解答
答案:1 悬赏:60 手机版
解决时间 2021-02-09 02:20
- 提问者网友：趣果有间
- 2021-02-08 04:34
oracle数据库sql窗口输入L键自动关闭整个数据库客户端，求高手解答
最佳答案
- 五星知识达人网友：话散在刀尖上
- 2021-02-08 05:45
oracle数据库sql窗口输入L键自动关闭整个数据库客户端
--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)
--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)
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯