/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

10 votes255 views4 answers
Inner join in update query mysql
SQL
31 votes260 views3 answers
SQL Server change column data type
SQL
45 votes318 views5 answers
Grant all privileges mysql
SQL
0 vote246 views1 answer
Version and edition of SQL Server Database Engine
SQL
7 votes286 views6 answers
Mysql group concat
SQL
0 vote266 views1 answer
Mariadb cast null to 0
SQL
5 votes265 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
10 votes257 views3 answers
How to fetch first 5 characters in sql
SQL
5 votes241 views1 answer
Oracle asynchronous procedure
SQL
0 vote263 views1 answer
Find usage of table in sql server
SQL