حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Round Values to nearest 5 in SQL

Nandan2k...

if value is 202, then round it to 205.

if value is 206, then round it to 210.

if 201 then 205

if 204 then 205

how to do plz suggest in sql

Shashika...

0 1

Hi,

Please refer below code.

SQL

DECLARE @i int 
SET @i = 201
SELECT ((@i+4)/5)*5;
SET @i =211
SELECT ((@i+4)/5)*5;

Output

205

215

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

216.73.216.187