/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

0 vote329 views1 answer
Mysql replication change database name
SQL
0 vote340 views1 answer
Drop constraint in ms sql
SQL
-1 vote361 views1 answer
Minus vs except in sql
SQL
1 vote354 views1 answer
Sql dcl
SQL
0 vote330 views1 answer
Sql server port 1434
SQL
0 vote321 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote356 views1 answer
How to get nth number in sql
SQL
1 vote342 views1 answer
Order by oracle
SQL
8 votes352 views2 answers
Sqlsrv default port
SQL
0 vote342 views1 answer
Setting default value for Boolean data type in SQL
SQL