/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

2 votes243 views1 answer
Remove foreign key constraints in postgres
SQL
4 votes317 views6 answers
Laravel jwt
SQL
1 vote219 views1 answer
Sql headers delphi
SQL
1 vote227 views1 answer
Limit offset order by mysql
SQL
0 vote178 views1 answer
Oracle sql replace string in clob
SQL
0 vote208 views1 answer
Sqlalchemy one column of two has to be not null
SQL
1 vote240 views1 answer
Mysql print variable
SQL
0 vote210 views1 answer
Sql get guid
SQL
-1 vote333 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote216 views1 answer
Power bi union columns
SQL