+ 1
SQRT()
How to minimize the query result to restrict to display upto 2 decimal points on using SQRT() function?
2 Antworten
0
.lenght
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