troubleshooting Question

oracle query

Avatar of anumoses
anumosesFlag for United States of America asked on
Oracle Database
3 Comments2 Solutions357 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros