/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

1 vote299 views1 answer
How to drop function in sql
SQL
0 vote294 views1 answer
Find number of entries sql
SQL
0 vote294 views1 answer
Mysql identified by syntax error
SQL
0 vote303 views1 answer
Show table structure mysql console
SQL
1 vote300 views2 answers
Restart identity cascade
SQL
0 vote246 views1 answer
Denied
SQL
0 vote302 views1 answer
Declare date variable sql
SQL
0 vote325 views2 answers
Mysql calcular idade
SQL
35 votes318 views6 answers
Postgres
SQL
0 vote329 views1 answer
Java sql insert return id
SQL