/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 vote281 views1 answer
Oracle execute immediate quotes
SQL
1 vote315 views1 answer
Create new index takes long time postgresql
SQL
0 vote322 views1 answer
Set engine to innodb
SQL
0 vote295 views1 answer
Oracle db get table sizes
SQL
0 vote297 views1 answer
Import sql dump into postgresql database
SQL
0 vote323 views1 answer
Show mysql account privilleges
SQL
0 vote316 views1 answer
Mysql query with sql to get the next row
SQL
9 votes287 views3 answers
Where in sql
SQL
1 vote444 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
1 vote327 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL