/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

9 votes188 views2 answers
Nosql databases
SQL
0 vote195 views1 answer
Mysql insert multiple rows based on select
SQL
1 vote164 views3 answers
Remove unique key from a table
SQL
0 vote185 views1 answer
Load utilities in sql server
SQL
0 vote173 views2 answers
Avg() sql
SQL
0 vote188 views1 answer
Groupby error in mysql
SQL
0 vote170 views1 answer
Mysql:5.6 syntax create table
SQL
1 vote182 views1 answer
How to change owner in postgres
SQL
6 votes186 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote177 views1 answer
Google sheets filter rows above current cell
SQL