/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 vote135 views2 answers
Get top 1 row of each group
SQL
0 vote148 views1 answer
Mariadb current date plus 1 day
SQL
0 vote146 views1 answer
Sql new line output
SQL
0 vote171 views1 answer
Sql mod even odd
SQL
1 vote162 views1 answer
STOP message of how many rows affected sql
SQL
0 vote152 views1 answer
Null column as zero in mysql
SQL
0 vote142 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote162 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote155 views1 answer
Postgresql if else endif
SQL
0 vote155 views1 answer
Nvl2 syntax
SQL