You are viewing a single comment's thread. Return to all comments →
Oracle:
--use CEIL function returns the smallest integer value that is greater than or equal to a number. --Example: CEIL(32.1) --Result: 33
select ceil(round(avg(salary) - avg(replace(salary,0)),1)) from employees;
Seems like cookies are disabled on this browser, please enable them to open this website
The Blunder
You are viewing a single comment's thread. Return to all comments →
Oracle:
--use CEIL function returns the smallest integer value that is greater than or equal to a number. --Example: CEIL(32.1) --Result: 33
select ceil(round(avg(salary) - avg(replace(salary,0)),1)) from employees;