/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 vote102 views1 answer
Oracle index hint
SQL
44 votes185 views6 answers
Rename command in sql
SQL
1 vote111 views1 answer
Mysql select utc time in eastern time
SQL
0 vote121 views1 answer
Mysql remove last character
SQL
4 votes149 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote124 views1 answer
Fetching data from mysqldb
SQL
2 votes103 views1 answer
Insert from table tsql
SQL
1 vote97 views1 answer
Sql Split string function
SQL
5 votes129 views2 answers
Get columns number sql
SQL
0 vote114 views1 answer
Mysql page segment
SQL