/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

28 votes155 views6 answers
Distinct sql
SQL
60 votes564 views6 answers
Add column in sql
SQL
0 vote212 views1 answer
Mysql get longest string in column
SQL
2 votes205 views1 answer
Power query concatenate
SQL
9 votes191 views4 answers
How to alter table column name in mysql
SQL
4 votes182 views1 answer
Delete record mysql query
SQL
1 vote192 views1 answer
Input in mysql
SQL
0 vote220 views1 answer
Sql server create constraint
SQL
0 vote180 views1 answer
Mysql multiple count
SQL
0 vote190 views1 answer
Alter table myisam to innodb
SQL