/SQL/Select mysql limit to 2 decimal places

Select mysql limit to 2 decimal places

/**
When formatting number to 2 decimal places you have two options TRUNCATE and ROUND.
You are looking for TRUNCATE function.
Examples:
**/

-- Without rounding:
TRUNCATE(0.166, 2)
-- will be evaluated to 0.16

TRUNCATE(0.164, 2)
-- will be evaluated to 0.16
-- docs: http://www.w3resource.com/mysql/mathematical-functions/mysql-truncate-function.php

-- With rounding:
ROUND(0.166, 2)
-- will be evaluated to 0.17

ROUND(0.164, 2)
-- will be evaluated to 0.16
-- docs: http://www.w3resource.com/mysql/mathematical-functions/mysql-round-function.php

Source: stackoverflow.com

Similar codes

3 votes271 views1 answer
Sql server version query
SQL
-1 vote295 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote280 views1 answer
Provide hardcoded value in the mysql query
SQL
1 vote281 views1 answer
Round function in sql oracle
SQL
1 vote268 views1 answer
Multiple count in sql
SQL
3 votes301 views2 answers
Check data in table mysql
SQL
0 vote255 views1 answer
Dns slave zone convert
SQL
10 votes238 views2 answers
Sql where clause multiple values
SQL
1 vote270 views1 answer
Sql server select rows by distinct column
SQL
0 vote278 views1 answer
Exectuer myssql .sql
SQL