Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL query help.

BugsMay 14 2014 — edited May 16 2014

My requirement is to get the result below:

(Reminder of my given number divided by 5) corrected to the closest rounded number of 5.

For instance , my number is "3".

13 = (2 x 5) + 3.

Closest rounded number of my number in multiples of 5.

3 x 5 =15.

15-13 =2

I'm looking for a query to get the result of "2".

Thank you!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2014
Added on May 14 2014
3 comments
166 views