+ 1

SQRT()

How to minimize the query result to restrict to display upto 2 decimal points on using SQRT() function?

29th Sep 2017, 12:04 PM
Ramya M
Ramya M - avatar
2 Réponses
0
.lenght
29th Sep 2017, 1:35 PM
Luka Bjelica
Luka Bjelica - avatar
0
Select CAST ((SQRT(25)) as decimal(16,2)) from Categories CAST -> give you the possibility to format the number SQRT -> is the operation you want to perform, 25 is just an example decimal -> format the number to decimal where 16 is the number before the comma and 2 is the number after the comma. result is 5.00
29th Sep 2017, 10:06 PM
sneeze
sneeze - avatar