/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 votes205 views2 answers
Change mysql password from command line
SQL
0 vote207 views1 answer
Unique index in mysql
SQL
36 votes205 views6 answers
Rename table sql
SQL
4 votes227 views1 answer
Search column by name mysql
SQL
1 vote202 views3 answers
Drop unique key constraint in sql server
SQL
0 vote194 views1 answer
How many columns can be used for creating index?
SQL
5 votes255 views1 answer
Purge undo tablespace usage
SQL
0 vote228 views1 answer
Mssql find deadlocks
SQL
1 vote190 views1 answer
Xampp import sql file command line
SQL
15 votes179 views4 answers
T-sql drop function if exists
SQL