anumoses
asked on
oracle query
select ds.payroll_id as payroll_id,
sum(ds.total_hours)/100 as sum_wk_hours
from dept_staff ds, not_avail_reason nar
where ds.schedule_date between '27-may-2012' and '02-jun-2012'
and ds.reason_code = nar.reason_code
and nar.pay_hours_flag = 'Y'
and payroll_id in ('ZZW0024403','ZZW0023632' )
group by payroll_id
PAYROLL_ID|SUM_WK_HOURS
ZZW0023632|28.75
ZZW0024403|32.25
I need to round it off 28.75 = 29
32.25 = 32
I have to use floor and ceil. How can I use both?
sum(ds.total_hours)/100 as sum_wk_hours
from dept_staff ds, not_avail_reason nar
where ds.schedule_date between '27-may-2012' and '02-jun-2012'
and ds.reason_code = nar.reason_code
and nar.pay_hours_flag = 'Y'
and payroll_id in ('ZZW0024403','ZZW0023632'
group by payroll_id
PAYROLL_ID|SUM_WK_HOURS
ZZW0023632|28.75
ZZW0024403|32.25
I need to round it off 28.75 = 29
32.25 = 32
I have to use floor and ceil. How can I use both?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER