/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 vote115 views1 answer
Vbscript create ADODB.Connection
SQL
3 votes194 views1 answer
Sql add two values together
SQL
5 votes120 views5 answers
Find max number in sql
SQL
2 votes125 views1 answer
Cast string to datetime mysql
SQL
0 vote123 views1 answer
Exclude last comma separated string mysql
SQL
0 vote128 views1 answer
Database traccar
SQL
4 votes116 views1 answer
Check database name postgresql
SQL
0 vote123 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
1 vote141 views2 answers
Setval max id postgresql sequence
SQL
-1 vote147 views4 answers
Postgres between dates
SQL