SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Create table Numbers (num int, frequency int); insert into Numbers (num, frequency) values ('0', '7'); insert into Numbers (num, frequency) values ('1', '1'); insert into Numbers (num, frequency) values ('2', '3'); insert into Numbers (num, frequency) values ('3', '1'); WITH data AS ( SELECT num, frequency FROM Numbers CONNECT BY PRIOR num = num AND PRIOR dbms_random.value IS NOT NULL AND LEVEL <= frequency ORDER BY num ) SELECT TO_CHAR(ROUND(median(num), 1), '0.9') AS median FROM data ; -- checks with a as ( select num, frequency, sum(frequency) over (order by num) - frequency as lower_num, sum(frequency) over (order by num) as upper_num, sum(frequency) over () / 2 as medium_num from numbers ) SELECT * FROM a;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear