/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 vote322 views1 answer
Mysql add to value
SQL
0 vote324 views1 answer
Insert array into mysql column
SQL
3 votes321 views1 answer
Oracle apex warning message
SQL
5 votes353 views1 answer
Add column table sql default value
SQL
0 vote341 views1 answer
Open postgresql.conf in centos
SQL
1 vote352 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
2 votes328 views2 answers
Get all columns from table sql
SQL
0 vote326 views1 answer
Mssql check if date is greater than today
SQL
2 votes360 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
13 votes342 views3 answers
Sql select from multiple tables without join
SQL