/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 vote122 views1 answer
Mysql percentage of total
SQL
23 votes139 views6 answers
Create table sql server
SQL
0 vote156 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote141 views1 answer
Drop index in sql
SQL
0 vote126 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote144 views1 answer
How to locate pg_hba.conf file
SQL
0 vote135 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
3 votes132 views1 answer
Show index table
SQL
3 votes147 views1 answer
Sql datetime as date
SQL
0 vote131 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL