/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 vote240 views1 answer
Oracle decode
SQL
0 vote192 views4 answers
Mysql count table rows
SQL
1 vote230 views3 answers
How to pass password to mysql command line
SQL
1 vote200 views1 answer
Postgresql reset serial counter after deleting content
SQL
1 vote223 views1 answer
Mysql order by desc null last
SQL
-1 vote231 views3 answers
Compute age mysql
SQL
0 vote232 views1 answer
Returning with sqlalchemy
SQL
0 vote219 views1 answer
Least spark sql
SQL
0 vote240 views1 answer
Mariadb alter table add column if not exists example
SQL
2 votes209 views4 answers
Sql query interview questions
SQL