select  stddev(salary) over(order by dept_id, emp_id) as bug1,
        stddev_pop(salary) over(order by dept_id, emp_id) as bug2,
        stddev_samp(salary) over(order by dept_id, emp_id) as bug3,
        var_pop(salary) over(order by dept_id, emp_id) as bug4,
        var_samp(salary) over(order by dept_id, emp_id) as bug5,
        count(*) over(order by dept_id, emp_id) as cnt,
        emp_id, dept_id, salary
from (
       select 100 emp_id, 'Steven' first_name, 'King' last_name, 24000 salary, 90 dept_id from dual union all
       select 101, 'Neena', 'Kochar', 17000, 90 from dual union all
       select 103, 'Alexander', 'Hunold', 9000, 60 from dual union all
       select 104, 'Bruce', 'Ernst', 6000, 60 from dual
    ) t;