/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

1 vote163 views1 answer
User privileges postgresql information_schema
SQL
0 vote161 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
3 votes232 views1 answer
Mysql cli connect with password
SQL
11 votes170 views1 answer
Oracle view ddl
SQL
0 vote181 views1 answer
Sql max of two values
SQL
2 votes168 views1 answer
Set column to not null mysql
SQL
3 votes177 views2 answers
How to load files in mysql
SQL
-1 vote177 views1 answer
Spring boot mysql connection properties
SQL
3 votes175 views2 answers
Oracle privileges users
SQL
1 vote129 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL