/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

6 votes295 views2 answers
What is non relational database
SQL
1 vote284 views2 answers
Mysql remove first and last character from string
SQL
9 votes270 views4 answers
Mysql show table fields
SQL
0 vote284 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote283 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
1 vote307 views2 answers
Grab part of a string sql
SQL
0 vote286 views1 answer
Zerar auto increment mysql
SQL
0 vote274 views1 answer
Use between operator in mysql
SQL
0 vote298 views1 answer
Mysql last 6 months
SQL
0 vote292 views4 answers
How to connect form to database
SQL