/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 vote181 views2 answers
How to prevent sql injection in java
SQL
0 vote142 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote140 views1 answer
ORA-13717
SQL
0 vote134 views2 answers
How to delete the rows with null values in mysql
SQL
1 vote132 views1 answer
Mysql check if string contains comma separated
SQL
1 vote133 views2 answers
Sql for date greater than
SQL
0 vote141 views1 answer
Oracle drop type
SQL
5 votes136 views2 answers
Postgres update with if condition query
SQL
0 vote144 views1 answer
Psql get table data types
SQL
5 votes230 views1 answer
Oracle asynchronous procedure
SQL