/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

18 votes199 views2 answers
Sql inner join
SQL
0 vote201 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
2 votes200 views1 answer
Mysql virtual column
SQL
4 votes207 views2 answers
Bulk kill mysql processlist
SQL
-3 votes196 views1 answer
Remove spaces sql 2008
SQL
0 vote216 views1 answer
List all indexes postgres
SQL
0 vote187 views1 answer
Metada in sql
SQL
-1 vote175 views1 answer
Mysql if example
SQL
9 votes194 views4 answers
Add primary key to existing table sql
SQL
0 vote202 views2 answers
Starting mysql service from mac
SQL