Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    India
    Posts
    11

    Post Answered: Rounding off to nearest 5

    Hi everybody !!

    I want to round off a decimal number to its nearest multiple of 5
    eg. 55.33 should be printed as 55.35
    22.22 should be printed as 22.20
    44.77 should be printed as 44.80
    Can anyone suggest an sql query for this requirement ?

    Thanks in advance,
    Sam

  2. Best Answer
    Posted by andrewst

    "ROUND(value*20)/20"


  3. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    ROUND(value*20)/20

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •