0

What if we need only 2 decimals by using 'sqrt' function?

For example, I want 3.16 for Square root of 10 instead 3.162277660

23rd Apr 2017, 5:49 PM
Azhagiri Narayanan
Azhagiri Narayanan - avatar
3 odpowiedzi
+ 4
quite straightforward actually lets say you want a rounded value of the square eoot of PRICE SELECT ROUND(SQRT(PRICE), 2) FROM Products
23rd Apr 2017, 7:32 PM
Burey
Burey - avatar
0
in SQL
23rd Apr 2017, 5:54 PM
Azhagiri Narayanan
Azhagiri Narayanan - avatar